wizcow
Registered User.
- Local time
- Yesterday, 17:38
- Joined
- Sep 22, 2001
- Messages
- 236
I am trying to repair a db.
The Invoice table has the Customer's name stored, but not the CustomerID.
I would like to repair the tblInvoice table data.
I'd like to have a query that looks up the customer name, then enters the proper customerID in the customerID field.
The customerID will have to come from the tblCustomers table.
I'm pretty lost with these update querys.
Tom
The Invoice table has the Customer's name stored, but not the CustomerID.
I would like to repair the tblInvoice table data.
I'd like to have a query that looks up the customer name, then enters the proper customerID in the customerID field.
The customerID will have to come from the tblCustomers table.
I'm pretty lost with these update querys.
Tom