Yes! By all means dump those 2 tables (sold and returned). Replace them with one table describing all attributes (properties) of the equipment. Add another table to track sales (or call it orders if you like that name). The tbl:Equipment should have additional fields to record the "quantity...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.