Cascading Lists

[veraloopy]

Apologies, this is probably one of the most talked about topics but despite following several answers on the forums, I'm still nowhere near to this working for me.

Basically, I have 2 lists, the first list contains sources of enquiries (i.e. Internet, Magazine, Newspapers, Referral, etc). The 2nd list is the individual items within the catergory based on list 1.
e.g. Google, MSN, The Telegraph, etc, etc.

What I need is for a user to select an option from list 1 (i.e. Internet) and List 2 will reduce to only show the internet sources (i.e. Google, MSN, etc)

Currently I have 2 tables, one for each list - is this where I am going wrong? Do I need 1 table with all the information in ??

Any help is very much appreciated

 

[ajetrumpet]

Cascades have so many different ways of working, they are impossible to count or to even explain anymore. I have written a faq on this personally if you want to check it out. Just search this forum for "cascading combo boxes" under my name as a "thread starter". As for this particular issue, i may be with the rest when i say, that if you upload your file, it will probably get fixed within the very short future if you would like.

 

[missinglinq]

Normally this would be done with one table as the source for both comboboxes, with one field for your "sources of enquiries" and a second for your "individual items."

The second combobox would be based on a query that pulled all "individual items" Where the "sources of enquiries" equaled the first combobox value.




(i.e. Internet, Magazine, Newspapers, Referral, etc). The 2nd list is the individual items within the catergory based on list 1.
e.g. Google, MSN, The Telegraph, etc, etc.

What I need is for a user to select an option from list 1 (i.e. Internet) and List 2 will reduce to only show the internet sources (i.e. Google, MSN, etc)