Hi everyone.
I got a problem that I cannot solve (yes, I'm a newbie).
So, I have a form and 2 tables that work with it.
Table_1 has an ID field and varchar field with set values.
On the form, there is a dropdown list to which information is being feed from varchar field of Table_1. When the form is being submitted all the information is being stored in Table_2 in relevant fields.
Up until now everything works great.
But the form can also be opened to edit the values that have been inputed there previously, and that's where I'm hitting a wall.
I open the form in edit mode, pull all info from Table_2 and set the default values to the form components.But the dropdown list will only show the value that was saved in Table_2, on the other hand, if I set that list to pull info from Table_1, user doesn't know what was there before.
So what I wan't to achieve is to have the dropdown list display all the values from Table_1, but set the default selection to the value that's stored in Table_2.
I hope I explained it clearly enough.
Thanks for help
