If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|