Change staff assignment dynamically

[twims]

Hi...Newbie here! This might be long, but I want to be clear...

I'm working on a database for my agency in which clients are assigned to
specific staff through use of a staff id number. For administrative purposes,
we have one *generic* client that is not assigned to a specific staff member.
However, each staff member must be able to save records for that client under
their ID number. Currently, I have a form to create client records that uses
cascading combos. In the first combo, the user chooses the staff member.
The second combo is then limited to the clients of that staff member. I have
set the underlying query up to include the *generic* client in each staff
members client list, but I cannot save records for that client. I get an
error message that indicates it's because the generic client is not assigned
to the staff member. Is there a way to temporarily assign that staff member
to the generic client, perhaps some sort of AfterUpdate event that is only
triggered when the staff member is chosen in the first combo?

Thanks for any help!

 

[Guest]

What is triggering the error message? Is it from the database or from code?
If it's from the database, you probably have a relationship between the
tables that prevents unrelated records. It's important for us to know where
this error is coming from.

Barry