I've currently got a requirement to populate some editable controls in the form with a value based on the result of a lookup to another list.
The runtime lookup function is great for displaying information from another list based on values from other controls in the form. Is there any way we can put this information into a textbox for example? e.g. When a user selects a department lookup, the form will look at a list containing approvers and get the person associated with the selected department and populate a person control.
Would appreciate any inputs or suggestions in meeting this requirement. Thanks in advance.