Linking Lookup Tables?

[CJUK]

Hi,

Apologies if this has been answered before.

I have 3 tables in my database

Table 1 fields : Car Manufacturer
Table 2 fields: Car Manufacturer (Lookup Table), Model
Table 3 fields: Car Manufacturer (Lookup Table), Model (Lookup Table), Price

In the third table I only want the models listed in the lookup table that are made by the Manufacturer that was selected in the previous field. Please help me accomplish this.

Thanks in advance,

CJ

 

[MagicMan]

Welcome to the forums

Your mixing tables and forms. Tables do not have selection options. Queries can have!
Anyways, either in the query or the form, use the selected model as a filter for the table 3 lookup. The rest will fall into place if the relationships are correct.

 

[boblarson]

Hi,

Apologies if this has been answered before.

I have 3 tables in my database

Table 1 fields : Car Manufacturer
Table 2 fields: Car Manufacturer (Lookup Table), Model
Table 3 fields: Car Manufacturer (Lookup Table), Model (Lookup Table), Price

In the third table I only want the models listed in the lookup table that are made by the Manufacturer that was selected in the previous field. Please help me accomplish this.

Thanks in advance,

CJ

If you are using lookups at table level, then by all means - GET RID OF THEM ASAP!!!! See here for why:
http://www.mvps.org/access/lookupfields.htm

And, you do not need to store the same data more than once. You should have an ID to save for a car instead of saving all of the information in each table. You then use QUERIES to pull the information together.

See here for more on normalization:
http://www.allenbrowne.com/bin/Access_Basics_Crystal_080220_Chapter_03.pdf


and how the rest works:
http://www.allenbrowne.com/casu-22.html