By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Organizing MS access Data

P: 16
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!
May 21 '08 #1
Share this Question
Share on Google+
2 Replies


JustJim
Expert 100+
P: 407
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
May 21 '08 #2

NeoPa
Expert Mod 15k+
P: 31,186
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.
May 22 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.