relationship amongst 5 product tables

[gg]

Hi!
I'm having to restructure my db so that the users can select from 4 dropdown
combo boxes. I have the following tables:
Table 1 has Prodtype (i.e. "DUMN"), Prodtype_descr ("Data Update/Maintenance")
ex. DUMN, Data Update/Maintenance
LICS, License

Table 2 has Pfee (i.e. DUPD),Pfee_descr (i.e. Data Update")
ex. DUPD, Data Update relates to Table 1's DUMN
LIRE, Republication License relates to Table 1's LICS
LISB, Sublicense relates to Table 1's LICS
Table 3 has Prodgroup (i.e. COMP),prodgroup_descr (i.e. Comparator)
ex. COMP, Comparator
DFEE, Data Feed
Table 4 has Prod (PDAW), Prod_descr (PDA Wireless App)
ex. PDAW, PDA Wireless App relates to Table 3's COMP and also to Table 3's
ASPRO
UDEF, User Defined Fields relates to Table 3's COMP

How do I build in relationships between Table 3 and Table 4 so that if COMP
is selected, only certain Prod options can be selected (and nothing from
those with DFEE in Table 3)? Also, what would the relationship be if user
selects DUPD from Table 2 so that the only valid options would be COMP and
DFEE from Table 3?
The ultimate goal is to get the product_no from the Product table. The
product_no corresponds to the concatenation of all 4 table fields (the
permutation of the valid combinations from all 4 tables).

Hope this isn't too wordy and confusing.

Thank you!

gg

 

[peregenem]

PDA Wireless App relates to Table 3's COMP and also to Table 3's
ASPRO

One column which 'relates' to two columns in another table? You didn't
mention 'ASPRO' in your definition of table3. Where is the definition
for Table5? For all your tables, data types and sample data would be
useful to know.