table only not form and data access page, drop down list to drop down list

[jcombalicer]

How will you make a drop down list that rely information from another
drop down list with the help of row source, sql and query not with the
of form, pages and vba.

Every department has different designation and every designation has
different section.....

Thank You!

[Neil]

User selects an item in Combo1 and that causes the row source in Combo2 to
change, right? Basically, you would place a reference to Combo1 in the SQL
for Combo2. Something like:

Select Field1, Field2 From TableForCombo2 Where
SomeField=[Forms]![FormContainingCombos]![Combo1]

Then, in the Combo1 AfterUpdate event, place:

Me!Combo2.Requery

Neil

"jcombalicer" <jc*********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

How will you make a drop down list that rely information from another
drop down list with the help of row source, sql and query not with the
of form, pages and vba.

Every department has different designation and every designation has
different section.....

Thank You!