This is my first question here in the forum, so please be patient with my lack of familiarity. I use FM Pro 11 and have a FM database connected to MS SQL Server pulling data from a series of 4 views. These views are added to my FM database as tables. There are not a lot of records in these views (ranging from 2300-10,500). but when I refresh window to get the latest data it is taking 5 minutes to completely refresh. I have tried using the script step in different combinations, but it does not help. Any ideas on what I may be doing wrong.
I have been working as a self taught developer for several years, but this is my first experience connecting to ODBC data sources.
Thanks in advance,