Accessing SQL Views

[utahfuntimes]

Quick question:

I have setup an external data source...using ODBC to look at a Microsoft SQL 2005 database. Everything is working fine. I can access the various SQL tables and add them to my FM solution.

ONE problem...SQL views. How do I access a view? I know how to access different tables...under manage database...relationships tab...I just double click my table, choose my datasource, and then I see a list of all the SQL tables to choose from. But I only see a list of tables...no views. How do I choose a view?

[utahfuntimes]

Well I found the problem... when choosing the external data source, there is an option for filtering by... with a views check box. I did not see it. Checking it now makes the SQL views show up.