I have 2 tables:
tblRegluarCustomers: ID, Name, Address, etc
tblSales: InvNum, custID, Name, Address,etc
(I decided to duplicate the Name and Address field in the sales table because many customers are only 1 time visitors, so I don't want to add them to my regular customers table)
My form has a combo box that allows the user to choose a regular customer and the customer ID is stored in the custID field.
My dilemma is that I want the regular customer's Name, Address etc to be displayed on the form when I select a customer from the combo box. If I don't select a customer I can just input the name myself.
thanks in advance
bushrat