I have a simple tblCustomer form with firstname, lastname, address, etc.
And a subform called tblBookings.
The tblCustomer "lastname" field needs to be copied over to tblGroup which has a primary key and a groupname field.
I would rather it be copied over than have the user enter it in a text box which could result in a typo and make the form less confusing for double entries. (The lastname is used as an identifier for persons travelling in a group)
The idea would then query the tblGroup with a combo box type field and choose the desired groupname for entry in the tblBookings.
I think I can do this on the frmCustomers: QueryBuilder properties but not sure how to do it.