Hi everyone need help with a data entry form.

[RobertSmith101]

Hi everyone, I have set a relationship between 2 tables my CustomerID in my Table CustomerDB is linked to (as a one to many) CustomerID in my CargoDetails table, however when creatng a data entry form for them both I am unable to have just one field for the data entry form that says CustomerID and it to enter the customerID into both fields in each table, can someone help me with this predicament please?

 

[Parra]

Create a query with the fields you want on the form, and have the form linked to the query.