DTB Design Question

[Kaylen]

Hello all, I've been struggling trying to design this particular database but
have been unsuccessful. I want to build a databse of medical groups data.
Every medical groups has the same list of contacts (MD, Admin, Case Manager,
etc.) but the contact information for each of these title are usually
different. I want to build a database so whenever a person enter in a new
medical group, a subform of a blank list of contacts will open so that the
user can enter in the contacts info of all the people of those titles.
Contact info will be phone #, Address, Fax, etc. Each medical group will have
their own list of contacts and I want to be able to fill in the fields for
each contacts. So far I have a table of Medical group basic info, a table of
titles, and table of contact info for each title. I dont know how to link
these tables together so that I can have main form of Medical Group info and
a subform of all the contact info for each group. Any suggestion is
appreciated.

 

[Jeff Boyce]

Kaylen

To "link" records from one table to another (i.e., Parent records to
multiple children records), you need to have a foreign key in the "child"
table to hold the ID of the parent row.

Regards

Jeff Boyce
Microsoft Office/Access MVP