Data Entry - multiple tables

  • Thread starter Thread starter Data
  • Start date Start date
D

Data

Please help! I am drawing a blank.
I have two tables that share the same primary key: Acct#
and Seq#. One table will be storing the "details" of a
repair, the other the "parts replaced". The details table
will be a one relationship with the parts replaced being a
many relationship (it has a part sequence key as a 3rd
pkey).

I am looking to do data entry into the forms and am
getting error messages (must have record in x before y).

Any ideas on what I am doing wrong and any suggestions?

Thanks for your help!
 
When creating a One to Many relationship you can't have the same fields as
Primary Keys in both tables. That will create a One to One relationship,
because the primary key has to be unique in the table. The Acct# and Seq#
fields in the many table should be foreign keys.
 
Back
Top