B
Blake D.
Forgive me if this has been covered previously, I did search but had
trouble applying what I read to my scenario. So, here goes...
I work in a drug rehab, and am working on a database that stores our
intake/discharge information. The database design is slightly ugly, I
inheritted it in worse shape and am slowly making changes. I'm trying
to add in the ability to track employee services, both direct and
indirect, to the database. I have the following tables (some detail is
left out):
tblClient
==========
Client_ID as PK (GUID)
FName
LName
tblEmployees
=============
Employee_ID as PK (GUID)
Employee_Name
Counselor (Boolean)
Active (Boolean)
tblServices
============
Svc_Code as PK (6-character Text)
Svc_Descrip
Require_ClientID (Boolean)
Allow_Multi_Client (Boolean)
tblTreatment
=============
TX_ID as PK (GUID)
TX_Counselor (1 to many on Employee_ID)
TX_Type (1 to many on Svc_Code)
tblClientSessions
==================
TX_Session (1 to many on TX_ID)
TX_Client (1 to many on Client_ID)
** These two are used jointly as PK
I've created a form that will allow me to select a counselor, a service
code, and some associated info not relevant to this (duration, date,
etc). What I need help doing is creating a subform that will list all
the client ID's in the system (I'll use various filter choices to
shorten it) on one side, and will let the user select a client and move
them (via an arrow button for example) to a list on the right (and a
corresponding button to move them back in case of errors). Then, when
the record is saved, the TX_ID and the Client_ID are writen to
tblClientSessions. I would like it to go one step further and even
limit the number of clients that can be selected based on the results
of the Allow_Multi_Client field if possible.
Unfortunately, I think my desire is currently beyond my knowledge,
hence why I'm posting here... I realize this isn't a short answer type
question, and I'll likely have follow-up questions for whoever answers,
but please, I could really use some help.
trouble applying what I read to my scenario. So, here goes...
I work in a drug rehab, and am working on a database that stores our
intake/discharge information. The database design is slightly ugly, I
inheritted it in worse shape and am slowly making changes. I'm trying
to add in the ability to track employee services, both direct and
indirect, to the database. I have the following tables (some detail is
left out):
tblClient
==========
Client_ID as PK (GUID)
FName
LName
tblEmployees
=============
Employee_ID as PK (GUID)
Employee_Name
Counselor (Boolean)
Active (Boolean)
tblServices
============
Svc_Code as PK (6-character Text)
Svc_Descrip
Require_ClientID (Boolean)
Allow_Multi_Client (Boolean)
tblTreatment
=============
TX_ID as PK (GUID)
TX_Counselor (1 to many on Employee_ID)
TX_Type (1 to many on Svc_Code)
tblClientSessions
==================
TX_Session (1 to many on TX_ID)
TX_Client (1 to many on Client_ID)
** These two are used jointly as PK
I've created a form that will allow me to select a counselor, a service
code, and some associated info not relevant to this (duration, date,
etc). What I need help doing is creating a subform that will list all
the client ID's in the system (I'll use various filter choices to
shorten it) on one side, and will let the user select a client and move
them (via an arrow button for example) to a list on the right (and a
corresponding button to move them back in case of errors). Then, when
the record is saved, the TX_ID and the Client_ID are writen to
tblClientSessions. I would like it to go one step further and even
limit the number of clients that can be selected based on the results
of the Allow_Multi_Client field if possible.
Unfortunately, I think my desire is currently beyond my knowledge,
hence why I'm posting here... I realize this isn't a short answer type
question, and I'll likely have follow-up questions for whoever answers,
but please, I could really use some help.