Organizing MS access Data

[bkendra5]

MS ACCESS 2003
ENGLISH

I have 3 main categories, Current Client, Past Client, Prospective Client. The sub categories would include associates, landowners, nurserys, producers, sawmills, timber tax.

I am lost, I dont konw how to make them connect. I could have a current client that is a timber tax client and also a producer. And right now I have it set up to "autofill" into each, but this would get messy after awhile.

My question is "how could I organize this more efficiently"

You can view what I have done so far at ** Link removed **

Thank you very much in advance!

[JustJim]

Hi
Without downloading and opening your zip files (just not going to do it!) I can't see what you have done yet, but I have two suggestions.

The first is to read Mary's now famous article on normalisation . It takes a bit of digesting but it really is what relational databases are all about.

The second is to consider what you have said in your post. You have Clients and you have some information about them. The clients have a "Current" type of information and a "Type" type of information (not wording this really well, am I). Anyway, each client can be one type of Current (Current, Past, Prospect) and each type of Current can apply to many clients.

Each client can also be one type of Type (Associate, landowner etc) and each Type can apply to many clients

This suggests that you need three tables - Client, Current and Type with one to many relationships between Client - Current and Client - Type.

Good luck

Jim

[NeoPa]

As JJ has hinted at, this is not how you ask a question on here.

The question should be expressed clearly in English for all to see and not rely on anyone downloading from what, for all we know, is an unsafe link.

This is not an accusation. I'm just trying to express what is simple common sense. If you want help, you'll either have to express the question clearly, or take pot luck that someone can make sense of what you've posted so far.

-Admin.