Auto Dealership: Trade table and Vehice table neccessary?

[Evergreen]

Am creating a database for an auto dealership, a one to many relationship.
One customer to many vehicles and many trades. Mostly one trade per car
sold, but somtimes two. Do I create two tables? A Vehicle table and a Trades
table. I have vehicles in stock I sell and trades purchased from customers
when I make a sale. Upon delivery that Trade vehicle must become a stock
vehicle. Since all fields are the same for both Vehicle and Trade, do I
create one table and have a control(on form) to convert the trade to a vehile
in stock? Or vehicle type? Also, I must be able to create a control button
to open a form with just Trade info.

Access 2003
Thanks! Kevin

 

[Lynn Trapp]

I can't imagine why you would need to use 2 tables. If you did that, then,
when a vehicle transitioned from being a trade vehichle to a vehichle for
sale, you would need to transfer the data from one table to the other. So,
without more information, I would say a vehichle type field would be the way
to go.