If I understand your questin properly, I think I have done something
similar. Inour case, we provide group services to groups of varying size.
90% of theinformation for each client remains the same, only teh clientid
changes. What I have done is set up an eep that fires when I exit the row.
I pops up a list of all cleints (names) registered for the service and the
user checks off all the clients that received that service. The eep goes
into a loop. Each iteration reads the next name on the list, looks up the
id and creates a record of that service based onthe information enterd by
the user and the id it just looked up.
Is this the kind of thing you need?
>> I have a service reporting table that usually collects values re:
face-to-face services between clinicians and clients. The values stored
are
the client id, staff id, date, service and units.
We have one department that performs general outreach services to a
non-client population. I've created a 'dummy' case id for these. The unit
value = the total units for the incident divided by the number of
participating staff members (maximum of six staff per incident).
I collect outreach incident information in another table (date, number of
staff, some demographic info on audience).
I'm trying to produce a service entry form that looks up service dates from
the general outreach table (ok so far), then the participating staff
members. Using these two values and known constants (service code, client
id) I can insert rows in my service table for each staff member to allow us
to credit staff with productivity for the incident. <<
