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.
Ex: View has
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).