How do I populate a table using a dropdown list which contains values from another table [closed]

asked 2014-06-23 14:04:03 +0200

IanP gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-26 00:07:19.657105