Report form/sub-form data...

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Hi

I have a form and a subform that the user enters/selects information for a
worker.
The Primary Form is based on a WORKER TABLE it's linked (Relationship) to
the JOB ID TABLE and a table called JOB DESCRIPTION which is a combination of
the two. This works fine. The main form the user enters info i.e. name
address etc and in the subform, there is a combo box used to select 1 or more
job descriptions for each worker....... The table called WORKERS TABLE now
includes (When looking at the table) each worker with the entered JOB
DESCRIPTION (indicated by a + mark next to each record and when clicking on
the + it expands with the detail of the JOB DESCRIPTIONS chosen for each
worker.

Now I need to report on this. I need to report on all workers and all job
descriptions associated with them based on the above.

If this makes sense to anyone, please advise or tell me what more I can give
you.
Using Access 2003
Thank you.
 
Create a query based on the Worker and Job Description tables. Then use this
query as the record source of your report.
 
Back
Top