Auto Dealership: Trade table and Vehice table neccessary?

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

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.


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Evergreen" wrote in message
...
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