I'm not sure if I worded the title accurately as I am having a hard time trying to describe what I trying to do (maybe that's the problem?)...
I have an .mdb database that stores information regarding clients in a supportive services program for the homeless. They come to us as Single Adult, Adult in Family, or Child in Family (field name: familytype in the table that keeps track of clients). When a Single Adult gets added, adjusting their data is a pretty straightfoward thing so no problems there. Where I am having problems is with people in families.
One of the quirky things about Adult in Family is that they come with children and sometimes even other adult family members. The program doesn't actually serve children but have to list children as distinct and countable clients because they come attached to the adult in family as a family unit. We are required to keep track of the number of family units, as well.
So the way I did it was to have a separate table called "familyname" that gives a family unit a distinct PKid and a table called "family" that links clients in families to a familyname/ unit. When a case manager wants to look at lists/ profiles of certain families, he/she goes to a form that lists the family names (frmfamilyunitslist) and clicks a button that opens another form that lists clients that are in that family unit (frmfamilymemberslist).
We are funded by HUD and they keep track of clients based on when they enter the program and exit the program. Obviously, every client that is listed has entered the program so the date of entry is a field on the regular client table ("entrydate".) However, since not everyone exits, I have a separate table that has a field that links the client (field: "exitclient") to a PKid incidence of exit and exit date ("exitdate".)
Since it is assumed that a family unit enters and exits a program together (a family that stays together... you get the drift), all the clients in a family unit have to have identical entry and exit dates. I got the entry dates to match up for families, so that's not a problem. What I wanted to do was to insert a command button on the form that lists the members of a certain family (frmffamilymemberslist) that, when pressed, will open another form that will allow a case manager to enter an exit date that will then create exit incidences for all the members of a family at once with matching exit dates....
Is there a code for this? Was my explanation too confusing?
I have an .mdb database that stores information regarding clients in a supportive services program for the homeless. They come to us as Single Adult, Adult in Family, or Child in Family (field name: familytype in the table that keeps track of clients). When a Single Adult gets added, adjusting their data is a pretty straightfoward thing so no problems there. Where I am having problems is with people in families.
One of the quirky things about Adult in Family is that they come with children and sometimes even other adult family members. The program doesn't actually serve children but have to list children as distinct and countable clients because they come attached to the adult in family as a family unit. We are required to keep track of the number of family units, as well.
So the way I did it was to have a separate table called "familyname" that gives a family unit a distinct PKid and a table called "family" that links clients in families to a familyname/ unit. When a case manager wants to look at lists/ profiles of certain families, he/she goes to a form that lists the family names (frmfamilyunitslist) and clicks a button that opens another form that lists clients that are in that family unit (frmfamilymemberslist).
We are funded by HUD and they keep track of clients based on when they enter the program and exit the program. Obviously, every client that is listed has entered the program so the date of entry is a field on the regular client table ("entrydate".) However, since not everyone exits, I have a separate table that has a field that links the client (field: "exitclient") to a PKid incidence of exit and exit date ("exitdate".)
Since it is assumed that a family unit enters and exits a program together (a family that stays together... you get the drift), all the clients in a family unit have to have identical entry and exit dates. I got the entry dates to match up for families, so that's not a problem. What I wanted to do was to insert a command button on the form that lists the members of a certain family (frmffamilymemberslist) that, when pressed, will open another form that will allow a case manager to enter an exit date that will then create exit incidences for all the members of a family at once with matching exit dates....
Is there a code for this? Was my explanation too confusing?
