Auto Dealership: Trade table and Vehice table neccessary?

From: Evergreen (Evergreen_at_discussions.microsoft.com)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 14:17:02 -0800

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

Loading