organizing group attendance info

davec

New member
Local time
Today, 08:35
Joined
Jun 19, 2001
Messages
6
I'm trying to develop programming that is as easy as possible for the front-end users. They are counselors who work with people both individually and organized as different groups. I have set up an IND form-query-table to document characteristics of each individual with whom they work, a GRP form-query-table to document aspects of the groups (including identification of the INDs whom make up each group as variables MEMBER1, MEMBER2, etc.), and an ACT form-query-table to document the user activities (characteristics and notes from individual sessions, group sessions, and other things). My problem is setting up a report showing the group sessions attended by a particular individual. I can generate a query with a separate record for each group session and variables indicating the individuals in attendance (IND identification #s are the data arrayed as MEMBER1, MEMBER2, etc. variables, with those missing screened out), but to generate a report on each IND I believe that I need to generate a query with records for each session attended by each individual (i.e., a query with a single IND identification # variable, and multiple listings of the group session characteristics. I believe that I either need to discover a better way to enter the original GRP data (the difficulty here is keeping it simple for the counselors; I'd prefer to have each group on its own form rather than a different form for each group member), or discover a way to manipulate the query that I discussed above. Can anyone guide me on this?
 
Maybe something like this:

IND_TABLE, with IND_ID as the key, and Name, Address, Phone, anything describing an individual and which they only have one of...

GROUP_TABLE, with GROUP_ID as the key, Group Name, similarly, items describing the group

MEMBERS_TABLE, with GROUP_ID and IND_ID making up the key. Relates an individual to a group. Might only contain those two fields. Just lets you relate individuals to groups.

IND_NOTES, with IND_ID and an autonumber as the key. Contains your "characteristics" for individual sessions. Set up this way, you can have as many notes per person as you like. I'd put a date/time stamp in, too.

GROUP_NOTES, with GROUP_ID and an autonumber as the key. Similar to IND_NOTES, but holds all the stuff for your groups.

To get groups by individual, join MEMBERS_TABLE to IND_TABLE by IND_ID, and to the GROUP_TABLE by GROUP_ID (both are left joins)
 

Users who are viewing this thread

Back
Top Bottom