This topic is locked

Can I use a View in a Lookup Table?

11/22/2009 9:24:45 PM
ASPRunnerPro General questions
P
paulwebb author

How can I use a 'View' created in ASPRunnerPro in a 'Lookup table' on Edit page - or do I have to put the view on the SQL Server to use it?
eg,
Link Field: ID

Display Field: "Ref" & " " & "Desc" - so you can see what the Ref is - which you can't do
So Table is a View : but do I have to create it on the server to use it?

Sergey Kornilov admin 11/23/2009

You need to create a view in SQL Server if you want to use it a source of Lookup wizard.