table relationships

  • Thread starter Thread starter David Sullivan
  • Start date Start date
D

David Sullivan

I currently have Three Tables Main one is called
Contacts and off of this I have a ContactID linked to a
table called calls, which has a one to many
relationship , the ContactID is an auto number, I have
had to create a new table called Employees which I also
wish to attach to the Contact Table and use the same
Field "ContactID2, but when I try to create the
relationship I only get a One to One relationship, anyone
got any ideas

David
 
David

From your description, it isn't clear what your field data types are in all
three tables. If you are saying that you have a tblContact, with an
Autonumber ContactID as a primary key, that makes sense to me. You mention
a second table, tblCall, but didn't mention a primary key. That table needs
its own primary key (?CallID), and a foreign key to hold a
tblContact!ContactID (of data type "Long", if ContactID in tblContact is an
Autonumber).

If you also wish to connect a tblEmployee as a one-to-many to tblCall,
you'll need a primary key ID in tblEmployee and a corresponding foreign key
in tblEmployee (see above for example).
 
Thankyou for your reply in answer to my queries, I found
out what the problem was and it was the fact I did not
have a primary key in the employees table which after
insertion has sorted he problem

Thankyou
 
Back
Top