Matching data in fields

W

Weebot

Joined
Jul 7, 2007
Messages
3
Reaction score
0
Hi



I am new to access and need help with the following and help will be appreciated.



I have a table which is to be updated regularly. The table1 only has one field which contains the:

Car manufacturer, Model, Mileage and Rental price

In the following format

BMW X5 on business plan 3250 (12 Month). 1000 Miles. ¶œ600.00 Rental



Table2 has the following fields

Car manufacturer

Model

Description



Can some one please tell me the best way to match car manufacturer and model between the 2 tables so the database can display the description in the report?
 
I don't see why you need two tables here...I would just put the description field in with the rest of Table 1
 
Table1 is updated weekly.



Table1 has vehicle from many different manufacturers, and each of the manufacturers has their own tables.

e.g. BMW, Audi, so on....



I need to match the cars in table1 to the manufactures tables as they contain the description for the vehicle.
 
Back
Top