4 Replies Latest reply on Dec 26, 2016 10:44 AM by philmodjunk

    Display execute sql result in table filemaker




      I was having a go at ExecuteSQL() function and its very handy. But I'm not sure how i can display data in table or in portal like view.


      I have a dashboard where I wan to display latest data for example, I would like to see last 10 newest customers, last 10 notes added, last 10 timesheet.


      My dashboard is obviously is assigned to show customers table.


      In relationship I have customers table linked to all other tables.


      My question is if i have portal; the portal will display related records of that customers only. So how can I use execute SQL script to display data in table.


      My second comes from this. I was looking at something called Virtual list. Can anyone explain what is that and how that can be used to display results in table or portal like way.


      Thank you