View Full Version : Update Table


mati
12-20-2001, 05:44 AM
Hi ! After the user is updating the first combo box of an Order form with the customer name which is taken from the table customers , the list box customer address on the same order form is automatically updated from the customers table by a VB code. The problem is that the customer addredd is shown on the form but is not updating the customer address field in the table Orders.

Pls. help me on this one.

chrismcbride
12-20-2001, 08:41 AM
You should not need to add the Customer Address information into the Orders table. That would be duplicating data. Once the data is entered into the Customer table it can be looked up by reference.
Chris