You are on the rite track. To get the info to display the values from the other tables rather than their id's you would need to alter the recordset that is on the results page. This recordset is independent of the search on the page so you can alter this without altering the search.
If you have a query that will get at the info like this for you then you should try using that. I think it may be easiest to just start with the existing query and alter it by adding in some JOIN statements to link the tables together. I really think that this would be the easiest way to get the results showing how you would like them.
