Wrong column/value being displayed in a combo box when getting results from a query
I have a form that has a multivalue field in it, being shown through a combo box. When I pull the data from a table I can get it to display a persons name but store their ID number in the table, making it more user friendly. When I reopened the form the names would appear in the field instead of the numbers, keeping them hidden. As shown