Table related to multiple tables by single ID

MrTumnus

New member
Local time
Today, 20:15
Joined
Sep 11, 2008
Messages
3
I am constructing a database which includes three tables containting contact details, loan details and enquiry details. I would like to be able to link the loan and enquiry tables to the contact table via the field contact ID. This would mean that one contact can have multiple loans and multiple enquiries. At the moment my tables will only allow me to display one subsheet so I contacts can have either loans or enquiries but not both. Please can you advise/point me in the right direction??
 
I think you'll need to use a form/subform to set these up the way you need.
 
Mkay thanks. I'm pretty n00bish I'm afraid so I may need a little more than that. I'd intended to set up forms for all of the tables anyway. The loan form includes an option to search the contact table or add a new contact and details such as total items loaned, last due date,then a subform includes the details of the loan item by item. If I leave what I have above and add forms will it be ok to have multiple tables refering to a single key? thanks for your prompt reply.
 
I think I understand your question correctly and the answer is yes. If you have a main table with a primary key field you can have multiple secondary tables with foriegn key fields that point back to the main table.
 
Sub data sheets are a nightmare. You need to build your own forms to get proper control and display of your data.
 

Users who are viewing this thread

Back
Top Bottom