I just created a view in my SQL Server database, and I want to use it in a lookup rule on a form. I set the selector to "Table/View", but the list of tables and views only includes tables. My view is missing.
I've already checked permissions. The view has the same permissions as the tables that work fine in other lookup rules. Also, since this environment has only development and training data, I'm accessing it using my own login--the same login I used when I created the view and tested in in SSMS.
Is there something special I have to do to use a view in a Forms lookup rule?
I realize troubleshooting this kind of thing on this kind of thread is impossible, but does anyone have ideas of things I should check?
I'm using Laserfiche Forms Professional Version version 10.3.1.635
Thank you so much!