 |  |  |  |  |  |  |  |
stock control guys
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I have it all set up for my satock control, I have the primary keys and foreign keys too, so in SQL how is it to update my stock control when I sell item so I could have products deleted from stock and inserted to sold_product tables please.
tbl_Stock ( stockID Primary Key)
tbl_product (productID PK stockID Foreign key)
tblProduct_sold ( a result of m:m relationship between tbl_sales and tbl_Product)
tbl_sales (saleID PK)
tbl_Stock ( stockID Primary Key)
tbl_product (productID PK stockID Foreign key)
tblProduct_sold ( a result of m:m relationship between tbl_sales and tbl_Product)
tbl_sales (saleID PK)
|
Similar Threads
- homework(easy): Java GUI/Netbeans using java.util.LinkedList (Java)
- Server (IT Professionals' Lounge)
- EPOS and QUICKBOOKS PRO (IT Professionals' Lounge)
- final year project advice (Oracle)
- final year project advice (Database Design)
- CRM Database (Database Design)
- Multiple store front stock control feed (Database Design)
- updating multiple tables (ASP)
Other Threads in the ASP Forum
- Previous Thread: trim function
- Next Thread: Problem with Input Form
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest ASP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection calendar changeable connection current database databaseconnection diagnostics dreamweaver excel fso html iis microsoft msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption server single specfic sqlserver sqlserverconnection toolkit web webserver windows7
