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.
My question is how to use a form to collect date and staff values for the
run and insert one row for each staff member. If we had six staff each time
it might be easier, but the number can vary. It feels like I'd need a
lookup for the date and a loop to fetch the staff id numbers and insert
those and the constants into the service table.
At this point my eyes cross.
Can anyone offer a general description to achieve such a thing?
tia
Dave Ebert
[EMAIL PROTECTED]
