Different Reports

[Acropolis]

I have several field job types, and each one requires a different worksheets.

Engineers could go out with multiple job types each day.

What would be the best way, that I can just select the engineer and the day and it prints all the worksheets for that engineer for that day or date range, without having to print each type of worksheet manually?

There is a table tblFieldJobTypes in which there is the job type, generic instructions for each job, if I added another field that referenced the report name for each job type, what would be the way to run through everything and print the correct reports?

I would like them all in one file, as quite often they get email out and i just select email from the open report.

Thanks

 

[Rx_]

Your title is vague and the question is very generic.
Please think about breaking this down into specific questions about programming.
There is another area on Theory & Practice if you are in the planning stage.
- cheers