How can I add to an existing table within a query form, i.e.?
I have a Table for:
“Main Client”
“Site they are in charge of”
“Site contact”
When inputting a new job with a new Client, Site or Site contact (not in the existing table) at the moment I need to update the relevant table first, then use the combo box in the form to add the information to the database. Can this be done automatically via the combo box? I have tried setting “limit to list” to NO but this does not resolve the problem.