Locked table and JOIN expression

  • Thread starter Thread starter Tia
  • Start date Start date
T

Tia

Major urgency!!!!

I'm trying to create a relationship with personal contact information
linked to a database that holds fields of it. An area manager is a
manager for more than one site. One table holds their personal
information and another table holds what sites they look after...I am
having difficulty linking the two as I'm not aware of primary and
secondary keys (do they have to be the same fields in both table?).
When i create a form it only appears in design view as there is an
error message displaying: "Type mismatch in JOIN expression Error
3615".

I appreciate the help and i thank in advance.
 
Tia said:
Major urgency!!!!

I'm trying to create a relationship with personal contact information
linked to a database that holds fields of it. An area manager is a
manager for more than one site. One table holds their personal
information and another table holds what sites they look after...I am
having difficulty linking the two as I'm not aware of primary and
secondary keys (do they have to be the same fields in both table?).
When i create a form it only appears in design view as there is an
error message displaying: "Type mismatch in JOIN expression Error
3615".

I appreciate the help and i thank in advance.
Click to expand...

Table "managers":

manager_id PRIMARY KEY
other fields...

Table "sites":

site_id PRIMARY KEY
manager_id
other fields...

Join the two tables on manager_id
 
Back
Top