Good day.
My main form has an Option Group (3 options) which stores the values into a table called tblPlayerInfo. I created a second table (tblAppointments) which cross-references the numerical option values to a text value which gets displayed in the datasheet of tblPlayerInfo.
My jam is that I have an excel file that is linked to the access database that displays the table, however the table in excel displays the numerical values of the option group rather than the text value.
Is there a way to display the text values in the excel table once it gets exported?