table related to 2 other tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that was fairly simple but as time went on, I had to
normalize the table into several others. I did this with Access but now one
of the relationships does not seem to work properly any more. My plan called
for one of my tables to be linked in a one-to-many relationship to 2 other
tables using the same field (the primary ky) and linking it to 2 other tables.

contact table: ID (primary key) in a one-to-many relationship to
transaction table: contact_ID field
and
contact table: ID (primary key) in a one-to-many relationship to
artwork table: contact_ID

unfortunately, the first relationship works perfectly and the second one
gives me no joy. The contact to artwork relationship gives me the ID (an auto
number field numer) instead of the contacts last name and it keeps adding new
numbers to the last name field. Is having one talbe linked to 2 other tables
the problem? or is it something else?
 
No. There is no last name field in the artwork table there is contact_ID
field which I was hoping would be the way I could call up a list of all
artworks purchased or owned by a particular contact.
 
If you do not have it already you need main form/subform linked master/child
on contactid.

I still do not understand your comment >>The contact to artwork relationship
gives me the ID (an autonumber field numer) instead of the contacts last name
and it keeps adding new numbers to the last name field.
 
Back
Top