B
Brook
Good Day all,
I was wanting to get feedback on the layout of my tables for my inventory.
I sell a unique item and each item has a unique serial number.
I currently have tblinventory that houses, serial#, designname, colours,
size, quality,etc, along with that, it contains information about shipping of
the item from my factory, shippingid, cost, shipdate, etc, as well as
information about the products pricing, pricebase, pricediscount, etc.
I was thinking it would be better to split the info into 3 tables, for
designdata, shippinginfo, and pricing info.
Would anyone agree?
Also, if I did this, how would I connect the tables without having to type
the same data into each table?
Thanks,
Brook
I was wanting to get feedback on the layout of my tables for my inventory.
I sell a unique item and each item has a unique serial number.
I currently have tblinventory that houses, serial#, designname, colours,
size, quality,etc, along with that, it contains information about shipping of
the item from my factory, shippingid, cost, shipdate, etc, as well as
information about the products pricing, pricebase, pricediscount, etc.
I was thinking it would be better to split the info into 3 tables, for
designdata, shippinginfo, and pricing info.
Would anyone agree?
Also, if I did this, how would I connect the tables without having to type
the same data into each table?
Thanks,
Brook