HI,
I'm sure this has been asked, and answered, numerous times already, but I will go through what I'm attempting:
I have a reference table with two fields: product code (which is unique) and product description.
What I want to do is populate another table with the product code (must allow duplicates) and the related product description via a form.
i.e. open a form with various fields. Click on the product code to display a combo/dropdown box (I've tried using a combo) with all the product codes and associated descriptions, click on the relevant one, which then populates that Product code field and also the description field on the form. Because the log table I'm populating has many records with the same product code and description, plus other fields with unique serial number, date of purchase etc, I can't use the product code in this log table as a key as it has to be unique of course, though It can be in the reference table:
So, the reference table has the following fields:
Field type size
Gelpadcode text 10 (unique item code
Gelpaddesc text 60
Log table to be populated:
Gelpadcode text 10 (many duplicates)
Gelpaddesc text 60 (as per reference table)
plus......various other fields to be entered by the user on the form to populate the log table.
I know the relationship is one to many, but just how to create a form/code to do this. I watched an excellent You Tube video on how to populate a training record based on an employee record but although works, only appears to be to create unique records in the table to be populated, i.e. one to one, as the key is the employee ID.
Not sure if that makes sense, but please ask if you require more info.
Much thanks in advance
steve