We need some changes to a products return database.
In the database we currently have to manually type in Contact Name, Phone Number, Address, Account Number and we want to be able to select the details from a combo box, and have it automatically populate the other relevant combo boxes - ie select account number and it will automatically populate the Contact Name, Phone Number etc fields.
We want to be able to choose any field to use to populate the rest of the fields, ie select acc num and it works, select contact name and it works etc.
Fields to be populate from another table within our database which we will provide complete with data.
We also want the returns number to auto generate when a new return is raised, with a unique number.
I have attached a screenshot of the database form.