How can I pull data from an MS-SQL view

Follow

venkat.ch

• October 11, 2017 20:22

How can I pull data from an MS-SQL view with a lookup into a dropdown list, radio button, or check box?

0

• 

  PD

  • October 12, 2017 19:12

  After selecting to do a lookup from a database, selecting the type of database, and entering the Global Access Token for the database, select the Manual tab. If you click on the little question mark icon, you will be given some very useful help. Basically, you will need to create a query that returns two fields, one named Name and the other named Value. An example of such a query is shown in the question mark help. It is, SELECT ColumnA _رةName_رé, ColumnB _رةValue_رé FROM MYTABLE1. By inserting the name of a view in place of the MYTABLE1, you can pull the data from a view.

  0

  Comment actions Permalink

Please sign in to leave a comment.