AnsweredAssumed Answered

Display execute sql result in table filemaker

Question asked by on Dec 26, 2016
Latest reply on Dec 26, 2016 by philmodjunk



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