If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DTB Design Question
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. |
#2
|
|||
|
|||
DTB Design Question
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 "Kaylen" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|