Hello again, mike60smart.
Thanks to your "RecordsLog.zip", I have managed to sort out / get my head around virtually all of the problems I had due to my ignorance.
Your introduction to SubForms was an eye-opener!
I am now OK apart from 1 point - using the Combo Box. Ignoring the Training Types, Machine Types & etc, the one unresolved issue is in the Delegate Table/Form, displaying the Customer or adding an existing OR NEW Customer.
I'll enclose a zipped version of where I am now at. It is simplified, but all the other issues I had are resolved.
So, I can display in the form, and the SubForm, both the Delegate and Customer details, but only when they have been entered.
I'm sure that I should be able to use the Combo Box to Select and/or Add a New Customer, when creating a new record in the Delegate table.
It works in the datasheet view on the SubForm, by entering a new Cust Name & Cust Address, but I can't select an existing one.
Can you place the last piece in the jigsaw, please?
Attached Files