Help with Designing Tables

[lspelman]

I'm fairly new to Access and not sure how to set up the following:



I have many consultants who perform many services and within some of those services there are many types (ie - One service could be District Dept and within that service type there are many depts)

So far I have a table for Consultants and Services but not sure where to go from there . . .

Any help would be appreciated.

Thank you

[alansidman]

The attachment in this thread should help you to understand what you need and then help you to design your db.

http://forums.aspfree.com/microsoft-...es-208217.html

Alan

[lspelman]

Thank you for that information. It was helpful.

I was getting hung up on the fact that not all services in my Services Table have many descriptions, only some of them. But it looks like I need to create a Service Description Table and only those Services that have descriptions will be linked by a Foreign Key.

I am new to a Forum and Access so forgive me if I'm asking questions already discussed. I tried doing a search on the topics but it is a little overwhelming.

Thanks again,
Leanne

[alansidman]

Ask all the questions you need to. That is what the forum is all about. A good source of information is Google. Also, I like to recommend that new users look at two links for information:

http://www.datapigtechnologies.com/AccessMain.htm

http://www.bluemoosetech.com/index.php

There are many more, but these two are my favorites.

Alan