If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form based on Multiple Tables with different PKs
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 |
Thread Tools | |
Display Modes | |
|
|