Hi there
I am a noob and have limited knowledge of access and no SQL knowledge.
I am trying to create a database for our service team.
I am logging Jobs to our customers for completion.
I am having trouble getting the customer data to automatically populate in the Jobs Form.
I want to be able to type the customer details and populate the address & telephone number etc.. Also if the customer is not in the list I would like the option to add them to the customer table.
I would appreciate any help, also simple instructions would be a bonus!
Thanks in advance
Kerry