Hi,
I've not done a lot of MS Access work and have been tasked with
creating a database to record and report on stages of complaints cases.
Each set of records for a case has a header, any number of complaint
follow-ups and any number of actions or outcomes against the case. Each
of these have different forms, with the case number being the
connecting key, and a date/time field.
Creating these individual records is not a problem. However, there is a
requirement to step through the entire case in chronological order both
for display and for reporting a full case history. This means using
mixed forms for the recordset. If there was only one form other than
the header I would use a subform but can't see how to mix them.
For my sins, I'm an ex Lotus Notes programmer and can picture how I
would do all this fairly easily. As I said, though, my Access is not at
that level as yet, but I'm sure there must be a simple method to do
something so logical.
Please could someone give me a pointer in the right direction?
Thanks,
Joan