R
=Ray=
I have a form that I am using to enter data into different tables (via a
query). I have a total of three tables. Two of them have the same primary key
pair, and most of the form fields are from these tables. That much works
fine, but I have one field that I need to enter data into a third table,
which has a different primary key, and I'm having problems.
This is an inventory database, where the PK pair for two tables is the Item
ID and the lot number. But I want to keep track of the suppliers in a
separate table, where the individual item and lot no. are irrelevant. This
third table is for listing contacts for each supplier (there may be multiple
entries per supplier). But I want the supplier list, itself to be defined
based on the suppliers that were entered via different records on the form.
I'm running into problems with relationships, PKs, or something else I don't
know.
Thanks for your help,
Ray
query). I have a total of three tables. Two of them have the same primary key
pair, and most of the form fields are from these tables. That much works
fine, but I have one field that I need to enter data into a third table,
which has a different primary key, and I'm having problems.
This is an inventory database, where the PK pair for two tables is the Item
ID and the lot number. But I want to keep track of the suppliers in a
separate table, where the individual item and lot no. are irrelevant. This
third table is for listing contacts for each supplier (there may be multiple
entries per supplier). But I want the supplier list, itself to be defined
based on the suppliers that were entered via different records on the form.
I'm running into problems with relationships, PKs, or something else I don't
know.
Thanks for your help,
Ray