Multiple entry between tables?

[joemillson]

Hi,

I could do with some help on a little problem. Im currently developing a database for my architectural practice. We work on a Project by Project basis so I have one table as the Job Database (effectively) and I have another table and layout with all our contacts (engineers, surveyors etc) each with their own record per contact. Each Project is a single record in the Job Database table.

I have a tab set up in the Job Database table called 'Contacts.' Ideally I would like to be able to add numerous contacts from records kept in the Contacts Table to this tab to allow me to see who is involved in each of our projects. I have managed to do this with just one contact by using a Primary Key as the Contact Name and accessing the record data by supplying the corresponding Foreign Key in the Contacts tab. But how would you do it for say 20 contacts?

Its just a general question really. All I need to do is see who is working on which job from my contact table records.

Any thoughts?

Thanks

Joe Millson

philipmillsonarchitecture.co.uk

[comment]

You have a many-to-many relationship between Jobs and Contacts - this usually requires a third "join" table. See a demo here:

http://www.fmforums.com/forum/showpost.php?post/246136/

Note that a name is not a good choice for a primary key.