I have a form where the main fields are populated based on the results of a query field.
Ex, Main Data (SQL) Source:
Secondary Data Source (Sharepoint List)
What I would like to do is create form fields that will automatically populate based on the contents of the text field.
Ex, (text field) Please enter your fruit of choice: [ Apple ]
(Field 2 - from main SQL data source) The color of your fruit is [ RED ]
(Field 3 - from secondary Sharepoint List data source) Your fruits code is [ 1001 ]
Any suggestions would be greatly appreciated.
View Complete Post