G
Guest
Hi
I'm hoping someone can help.
What i am trying to achieve is when i select a value in the first combo box
that the values in the second combo box dispalys only those values related to
the selection in the first combo box.
For example i may have the following; DEPARTMENT- finance, HR, sales and
customer services.
the finance department may have the following sub departments; cashiers,
banking and reconciliations.
What i'd like is that when i choose the DEPARTMENT Finance in the first
combo box that the second combo box (SUB DEPARTMENT) only displays; cashiers,
banking and reconciliations.
I believe that the query SELECT DISTINCT maybe part of the answer but I
imagine it depends on how your tables are set up.
Any help would be greatly appreciated.
Thanks
I'm hoping someone can help.
What i am trying to achieve is when i select a value in the first combo box
that the values in the second combo box dispalys only those values related to
the selection in the first combo box.
For example i may have the following; DEPARTMENT- finance, HR, sales and
customer services.
the finance department may have the following sub departments; cashiers,
banking and reconciliations.
What i'd like is that when i choose the DEPARTMENT Finance in the first
combo box that the second combo box (SUB DEPARTMENT) only displays; cashiers,
banking and reconciliations.
I believe that the query SELECT DISTINCT maybe part of the answer but I
imagine it depends on how your tables are set up.
Any help would be greatly appreciated.
Thanks