Meshal
|
| Posted: 06/10/2003, 5:54 AM |
|
Sorry if what I am writing does'nt seem to be writen by a professional, because I am not actually :)
I just would like to understand how custom updates works.
I am having three tables one is RentOrder, Status, and the other is CarStatus.
When a car is rented, I need to modify its status to 2 which is (Rented) in the CarStatus table.
How can I do this with a custom update code?
RentOrder (RentOrderID(PK), CarID, CustID, EmpID, Date)
CarStatus (StatusID(PK), CarID(PK))
Status (StatusID(PK), StatusName)
Would you please help me doing that?
Reagrds,
|
|
|
 |
Meshal
|
| Posted: 06/10/2003, 6:02 AM |
|
I forgot to say that I am using
MSAccess, ASP, IIS, CCS2.1
|
|
|
|
|
