I am creating an inventory control database, and my products are using serial numbers, I am stock in desinging the tables needed .
Produts in stock 50
I need to store 50 serial numbers for that product.
One product number has many serial numbers.
Products can be in many locations (loc 1, loc 2 ...)
So I need to receive my stock enter the total quantity and its initial location and record all serial numbers.
Those products will be given to technician to put in there truck for install.
I need to transfert ex: 10 product xyz in his truck and transfert the location to his truck number and the serial numbers of those 10 products xyz.
I cant seem to visualize the tables and relations.
Can anybody help please.