nmartineza
Registered User.
- Local time
- Yesterday, 16:56
- Joined
- Mar 24, 2014
- Messages
- 14
I work at a mental/behavioral health facility and I use Microsoft Access to collect information on incidents regarding our adolescent clients.
The database is really basic, I have one table that stores client information, one table that stores the incident information, a query that links both tables, a lookup query based on client info table so staff can select a client from a combobox to add an incident, and five forms: main menu form, add new client form, edit existing client form, add incident to client form, and edit existing incident form.
The premise is that staff have to enter basic information on a client in the new client form, and they can lookup the record through a combobox in the edit existing client form. In the add incident to client form they can select a client in the combobox and add the incident information, and in the edit exiting incident form they can select and entered incident for modification. It is a two level structure, one client, multiple incidents.
My problem is that, clients switch program units consistently, and that's why I provided the editing opportunity for staff, so they can go to the edit existing client form and change the program unit. My only problem is that when they change the program unit, it changes it to all the records linked to that client. So all the incidents that occurred for a client in the "south" unit in the month of August, now are changed to incidents taking place in the "west" unit in the month of September. This creates a problem for my analyses because they are not representing the data accurately. The best way for me to deal with this is to ask about the program unit on each incident that gets entered, but this is a burden to staff when hundreds of incidents get entered on a monthly basis. I was wondering if there is a way to modify program unit on a client, and make sure that the modification is only reflected on data entries after the modification, and that the previous information is left intact.
The database is really basic, I have one table that stores client information, one table that stores the incident information, a query that links both tables, a lookup query based on client info table so staff can select a client from a combobox to add an incident, and five forms: main menu form, add new client form, edit existing client form, add incident to client form, and edit existing incident form.
The premise is that staff have to enter basic information on a client in the new client form, and they can lookup the record through a combobox in the edit existing client form. In the add incident to client form they can select a client in the combobox and add the incident information, and in the edit exiting incident form they can select and entered incident for modification. It is a two level structure, one client, multiple incidents.
My problem is that, clients switch program units consistently, and that's why I provided the editing opportunity for staff, so they can go to the edit existing client form and change the program unit. My only problem is that when they change the program unit, it changes it to all the records linked to that client. So all the incidents that occurred for a client in the "south" unit in the month of August, now are changed to incidents taking place in the "west" unit in the month of September. This creates a problem for my analyses because they are not representing the data accurately. The best way for me to deal with this is to ask about the program unit on each incident that gets entered, but this is a burden to staff when hundreds of incidents get entered on a monthly basis. I was wondering if there is a way to modify program unit on a client, and make sure that the modification is only reflected on data entries after the modification, and that the previous information is left intact.
