Unanswered: Access 2000: Select name from list but use ID in query
We have a publications database of geological books, maps and digital data that we produce. Each publication is assigned an area (townships, NTS, MNR Area) based on the study area. I am trying to create an Access search tool (the data resides in our Golden Oracle Database) to query the publications database. All of it works but I am going back now after having created it several months ago and I noticed a piece of code I would like to revise.
To search by geographic area, I provide a list of areas (townships for example) and the user selects one or more. In the townships_master table, the township name is tied to a township id (for example Gerow = 1234). The problem is that I don't know how to use the ID to search for publications - I created a workaround whereby I search the townships table for "Gerow" to get the ID (1234) and then I search the publications_area junction table for ID=1234. Is there any way of displaying the list of human-readable names but directly tying the names to the ID so that the intermediate step of querying the townships_master table for the ID may be removed.
I know how to do it on web forms - the "name" attribute can carry the ID while the user selects the name from the list but Access works a little differently.