Cascading combo issue

[Guest]

I have a combo box with which users choose a particular staff member. There
is a second combo that is then limited to clients of the staff member chosen
in the first combo. It all works great except for one problem: I have a
"generic" client that is used for certain types of records and I need for
this client to show up in the second combo regardless of which staff member
was chosen. Currently, this "generic" client is not assigned a staff member
at all.

Is there a way to accomplish this?

Thanks in advance!

 

[Guest]

yes if you are using an underlying query just include the name of the generic
client. If you are using code include the name of the generic client in the
where clause.

 

[Guest]

Thanks DMV! I got it to work, but there's another issue now that I hadn't
thought about. The query includes the "generic" client, but the staff ID is
null. I need it to use the requested staff members ID. I know there's a way
to assign a value instead of allowing nulls, but I'm not sure how to go about
it.

Thanks!