Well you really arent giving a lot of details as to where you are having a problem.
What you probably want to do is create a relational database
The routes in one file
the runs in one file that has a field with the route they belong to
the names in a third file that has a field for the run they belong to
link the name file to the run based on run number and the run file to the route based on route number
Then what you want to do is create a report not a form from the querry
got it. and you want an access data base that will print that out. for each route etc
give me a day and i will try to get one set up for you.
the number of records makes no difference. The structure does.
can you send me a small sample of the data base so i can see how you have laid out the tables and fields ?
You can email it to [email protected] and ask them to forward it to me. Give my name and the question
or you can post to something like www.wikisend.com