Consignment Database Structure???
Posted on 1998-08-30
I am setting up consignment database for a friends store. I have 2 related questions. The database of consigned inventory includes brand#, model#, quantity, condition of item, etc fields. First Q: When it comes to selling these consigned items, items sold may not equal items consigned. What's the best way to setup the data structure to handle this? Second Q: How should sales be handled? - Posted to another table i.e. 'Sold Items Table'?? or recorded as a 'negative' quantity of that item????
Thanks for any constructive suggestions...