R
rsm169
I created an Inventory Control Database using the template in Access 2000. My
only problem is that the products table does not meet my needs. I need to
replace the Products table with about five new tables. I want to start small
so for now I have replaced The Products table with two tables, one called
Drills, and one called Inserts.
First, how do I properly relate the two new tables to the Inventory
Transactions table?
If I can get that far I should be able to handle the rest.
Thanks
only problem is that the products table does not meet my needs. I need to
replace the Products table with about five new tables. I want to start small
so for now I have replaced The Products table with two tables, one called
Drills, and one called Inserts.
First, how do I properly relate the two new tables to the Inventory
Transactions table?
If I can get that far I should be able to handle the rest.
Thanks