AnsweredAssumed Answered

Display execute sql result in table filemaker

Question asked by muhammad.ikram@contedia.com on Dec 26, 2016
Latest reply on Dec 26, 2016 by philmodjunk

Hello.

 

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

Outcomes