A unique ID for each row, also automatically after inserting anew row.
Hi Ronald
Firstly, Is this meant to be a form of Inventory Control for Inwards & Sales/Dispatch?? If so, this would be far more efficient if it was in a database, that aside.
Your structure is ( IMO ) slightly skewed, here's why. It would be better served as follows:
Category No:
Product Code:
Item Code:
Box Qty:
Box Size:
Box Color:
Brand:
Supplier:
Movement Type: ( In / Out )
Date:
The reason for the date is it covers the date/time when the product was added to, or moved out of stock.
I could be way off the mark here, and someone else may have something more to your liking. Personally myself, an MSAccess Database or similar DB like MYOB ( which has in/out stock control ) may be a better solution as it keeps all your records in one container where all activity is recorded.
HTH
Cheers
Mark.
|