| SQL Questions [message #244] |
Thu, 31 January 2002 15:31  |
Hammamur
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
Hi, I have a few sql questions.
1) I want to update the field of one table after a user enters something in a another tabele. e.g.
In the Products table there is field called stock count. I want this field to be decremented after a field called quantity sold is updated in the sales order table.
2) How can you restrict/check that a user has enterd a valid id number. e.g.
I have a customer table, which has a key field called customer number. When sales order information is enterd in the sales order table, there is a customer number field whcih needs to be also entered. How can I check that a user has entered a customer that exists in the customer table?
Thank you very much.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
