I think I am missing something obvious and am pulling my hair out over this. I have a query with a field called approval type. The choices in approval type are called from a table. The bound column is the Approval type ID number but what the user sees on the screen is the approval type name...