I have a database with a main table representing people and a bunch of support tables which represent demographic characteristics of those people. The main table has ID#'s for corresponding descriptions in the support tables and I need to figure out how to translate the ID's to Descriptions.
For instance, the main table (tblMain) has a field "Race_ID" which corresponds to the "ID" column in the "Race" support table. (e.g. 1|White, 2|Black, 3|Asian, etc).
I'm trying to figure out how to get the "Race_Description" field from "tblRace" where the "Race_ID" field in "tblMain" matches the "ID" field in "tblRace".
How can I do this?