Hi, I'm relatively new to Access.
I have two main tables, essentially these are item masters with unique records: "SupplierParts" & "MyParts"
Many supplier parts can relate to one MyPart i.e.:
Etc...
I have created a third table ("ItemLinks") to link the two and this has fields: "MyPartNum" & "SupplierPartNum".
I want to use a form to append records to the "ItemLinks" table, creating a new record for each MyPart and SupplierPart combination. The form needs to validate (i'm thnking drop down lists) both MyPart and SupplierPart to ensure they exist and prevent data entry errors.
Can anyone suggest how I might achieve this?
TIA,
Towners
I have two main tables, essentially these are item masters with unique records: "SupplierParts" & "MyParts"
Many supplier parts can relate to one MyPart i.e.:
MyPart | SupplierPart |
Part1 | Part1 |
Part1 | Part2 |
Part1 | Part3 |
Etc...
I have created a third table ("ItemLinks") to link the two and this has fields: "MyPartNum" & "SupplierPartNum".
I want to use a form to append records to the "ItemLinks" table, creating a new record for each MyPart and SupplierPart combination. The form needs to validate (i'm thnking drop down lists) both MyPart and SupplierPart to ensure they exist and prevent data entry errors.
Can anyone suggest how I might achieve this?
TIA,
Towners