I have an editable form connected to SQL table A that has fields: item, comment, loss_type
I also have a dropdown list connected to SQL table B - this table contains all possible loss_types that I want to assign to an item from the form.
There is nothing in common between tables A and B.
In general what I would like to do it: I select and item, insert a comment manually (this I already have), then select the loss_type from the dropdown list and I would like the selected loss_type to appear in my form in the field loss_type so that I can submit it together with the comment. How can I acheive that?