Good morning all,
For my latest conundrum:
I am querying a main table which contains a foreign key linking information to a foreign table. The results of the query are outputted to a form. I have the form set up with a combo box for this particular field. Users can choose from the combo box, and then run an update query to change the information in the table.
The problem is, the foreign table is also being changed.
Let's say the foreign table looks like this:
1 A
2 B
3 C
If the current record has '2' stored in it, to represent 'B', and a user changes the selection to 'C' and runs the update query, 'B' is replaced with '3' in the foreign table, and '3' is stored in the main table.
Obviously, I want '2' to be replaced with '3' in the main table, but not the foreign table.
How do I fix this?