I am working with 3 tables for the current scenario: tblClient,
tblResponsibleParty and tblAppointment.
My form for entering or viewing client information is linked to tblClient
and tblResponsibleParty (with a responsible party ID field - one-to-many
relation****p) so when I add a new client, I have a drop down to choose the
responsible party (many clients have the same responsible party, for
example
Medicaid, which is why there is a separate Responsible Party table).
Therefore, if I view the form for a client, the responsible party
information
is also there.
My form for entering a new appointment is linked to tblAppointment,
tblClient and tblResponsibleParty. When I add a new appointment, I have a
drop down to choose the client and once they are selected, the client
information and responsible party information fills the form.
My question is this: Occasionally a client will tem****arily have a
different responsible party from their normal one. For example, medicaid
would pay for medical appointments, therefore the responsible party for
that
client would be medicaid. If they want to go shopping however, either the
client themselves or perhaps a relative would be the responsible party.
When
that occurs, I need to be able to change the responsible party just for
that
appointment without it changing the client file.
I hope that makes sense. I can provide further details if it does not.
|
