I'm trying to create a data entry form, which puts information into a specific table, but has 2 fields that looks up information from a different table.
I want the 'Account Name' and the 'Account Number' to be found from the 'Accounts' table, the 'Customer Number' field generates an AutoNumber, and the other fields will be entered manually.
The save button will, obviously, save the record.
The Exit button will close the form.
The Clear Fields button will erase all data from the form (i need help with this step too)
The idea is that there are multiple Customer's linked to a single Account, via the Account Number.
You select the account you want to associate the customer with, then fill in the details and save it.
Saving it will store all the information in the 'Customers' table.
I can successfully select an account name, however it will not populate the Account Number field when selected. This causes the 'Customer' to be related to no account from the 'Account' table.
In the below image, you can see customer number 1, i manually input to and associated the account number (this worked, and was recalled for other test forms).
Customer 6 was saved using the form in the above image.
I appreciate your help