G
Guest
This is going to be long...Please bear with me. I want to be as clear as
possible.
I have a table that includes client information, including which staff
member they are assigned to. One *generic* client is not assigned to a staff
member and is used only for administrative purposes, however all staff
members need to be able to add records for this *generic* client under their
staff ID. I have a form to add records for clients with 2 combo boxes, one
with staff member and another that is limited by the first combo. Only the
clients whose staff member who was chosen in the 1st combo show up in the 2nd
combo. Here's where the problem is: I have the underlying query set up so
that regardless of which staff member was chosen, the generic client will
show up in their client list. However, I cannot add a record for that
generic client. I get the error message "Microsoft Jet database could not
find a record in TblStaff with a matching key". I'm assuming that this is
because the client is not assigned to anyone. Is there a way to temporarily
assign this client to a particular staff member when the staff member is
initially chosen in the first combo box?
Thanks for any help!
possible.
I have a table that includes client information, including which staff
member they are assigned to. One *generic* client is not assigned to a staff
member and is used only for administrative purposes, however all staff
members need to be able to add records for this *generic* client under their
staff ID. I have a form to add records for clients with 2 combo boxes, one
with staff member and another that is limited by the first combo. Only the
clients whose staff member who was chosen in the 1st combo show up in the 2nd
combo. Here's where the problem is: I have the underlying query set up so
that regardless of which staff member was chosen, the generic client will
show up in their client list. However, I cannot add a record for that
generic client. I get the error message "Microsoft Jet database could not
find a record in TblStaff with a matching key". I'm assuming that this is
because the client is not assigned to anyone. Is there a way to temporarily
assign this client to a particular staff member when the staff member is
initially chosen in the first combo box?
Thanks for any help!