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!
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!
