gcj-davegri-v01.zip
See attached db.
It combines all the subscriber tables into one new table, tblSubscribers.
tblSubscribers contains a foreign key pointing to a new table, tblRoutes. This serves to determine which old table each subscriber in tblSubscribers was in previously.
All the old tables are in tblSubscribers except for [Seattle Dist Mixed States] because it has a slightly different format from all the others. If this is resolved, it can also be added.
The new form allows you to lookup any subscriber, regardless of the route. There is also a filter dropdown to restrict the form to a specific route if desired.
This is just a start for converting the application to a more modern configuration. Additional custom switchboard forms and coding will be needed to accommodate all the necessary functionality.