How can I pull data from an MS-SQL view

追蹤

venkat.ch

• 2017年10月11日 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

  • 2017年10月12日 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

  評論操作 永久連結

請登入寫評論。