So, I think this would be a very common situation and hope to solve it as it's arising a lot.
Here is an example.
Data
production.id, production.status_id, status.id, status.name
Query1 - get production and status
SELECT *
FROM production as p
LEFT JOIN status as s
ON p.status_id = s.id
Query2 - get status details
SELECT *
FROM status
Table1
Column1 - production.id
Column2 - status_id
Column3 - status_name
Column3 is an editable "dropdown tag" with the mapped data set to Query2
Value = query2.status_id
Label = query2.status_name
The user can change the status_name and then save the changes.
The challenge is that I want to update the production.status_id in this case.
This works ok if the user actually changes Column3 but if they change Column4, for example, and save the changes, the value sent for Column3 is the status_name, not the status_id.
If they make a change to the status_name on Column3 is will then update the "value" to status_id as set in the dropdown.
I've been trying to work around this for many hours and tried many things, but I'm sure I'm missing an easy solution here.
Hopefully I've explained this clearly enough. Thanks again