Hi All,
I’ve got Table1.
One of the fields is Table1.Status, it’s an integer.
There are a finite number of different statusses.
I’ve got Table2 which contains two fields,
Table2.ID (integer, primary key)
Table2.Status (text).
I’ve got a query which correctly links Table1.Status to Table2.ID
I’ve got a form with a listbox. It shows a list of Table2.Status. When I select one of the options, it correctly populates Table1.Status with the correct integer from Table2.ID.
However, if I use the form to go to an existing record, and try to select a differrent option, it refuses to save the modification, saying “Error updating the current record”
What am I doing wrong?