I'm currently creating Inventory System using VB6 with MS ACCESS for database using the Adodc and Datagrid commands. This project is for school requirement.
I have two database tables which are the STOCKS and ROOMS. I can easily Add/Edit/Delete Items in Stocks and Rooms but my problem is the relationship between the STOCKS and the ROOMS. What I really want to happen is when I add Items on Rooms, that Item will be deleted on stocks. Please help me :(
- 13 views