Using an Access query...

I have 3 tables related to each other...table1, table2 and table3.

Table2 has subrecords of Table1 records...Table3 has subrecords of Table2 records - a drilldown.

As well as looking at the 3 tables individually from Runner menu, I need to have a view of all the records in Table3 with their associated Table1 and 2 data. So I created a query - say OverviewQuery - in the Access database to create the Runner view I need.

This works fine, except it appears a Query in Runner is inherrantly uneditable therefore all I see is id numbers in the fields, I have no way to edit the lookups and show the valuename instead of the id number for fields.

I kind of rigged it by copying the code out of each of tables 1,2 and 3 list.asp into OverviewQuery's list.asp. But I would have to do that everytime I compile the code...in addition, I can't get lookups set so they show up in the advanced search in the query.

Any suggetsions? A better way to do this? Any way to paste some code into the project file in the queries field sections to make them use the lookups?
(BTW - we don't need to edit data in this query view - just view, search and export)
Thanks!!