Biil of sale for a Car lot
I am designing a data base for a car lot. the problem I am having is that I take trade-ins, and on the bill of sale I have to enter trade in information, so I have created 2 tables. one for the inventory and one for the trade-in. Once the bill of sale is created that trade-in info has to got to my inventory table, as that's where all my reports and costs and everything is based on. a little unsure as to how to handle this, knowing that duplicating information is not always the best way to do things. Any ideas?