AnsweredAssumed Answered

View with 7k records

Question asked by ramteja on Nov 14, 2016
Latest reply on Nov 15, 2016 by philmodjunk

I am a new bee to the FMP..  I am working on a small project..

 

We have oracle view with 7k rows and need to use selective records from it in the layout.  Created a local table and setup a relation to the view on a field.

But the portal in the layout is taking forever to display the data.

 

Any suggestions?

 

Ex: View has

 

StoreNumber,StoreCity

 

I created a local table (Cities) with 10 rows of store locations (like LA, Newyork, DC etc.,) and want to display the records from the view related to the records in the local table(Cities).

Outcomes