'Form entry is changing the values in my Lookup table
So, I I have two tables 1. Main table 2. Status table. I want too, in a form, have the user select the status from the status table and it populate to the main table. I created a query bring in the status table and create a Option 3 Join. In the form I created the combo box pulling the list from the statusTBL this updates the main table with the ID (Auto#) the query with the value, and the report with the value. All good right, well no what is happening is it is randomly changing the data in the Status table to numbers. So where I once had "Started" it changed the value to a number "13"enter image description here.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
