Hi everyone
I have a form using Sharepoint List A with a dropdown referring another sharepoint list B, when the options are selected, I am only updating sharepoint list A with the value selected on the dropdown. This works no problem
My issue starts when I dispay or edit the form. The field is empty but there is a value on sharepoint list A. How do I pull through the value to show when the form mode is edit? Also the column in sharepoint list A is a single line of text whereas Sharepoint List B is a table with 2 columns(Title and description), which is what you see contatenated in the dropdown.
Should the user try to edit this field they should be able to see the drop down options as well not just the single line of text.