I have my question about Excludesql command on filemaker
Hi Team filemaker
On filemaker can include sql command to layout ? i want to create query for display the reuslt to table
I believe that you are referring to ExecuteSQL()
This is a function, so the results of the SQL query are returned to a field or variable. It cannot be directly used as the record source for a layout.
It could be used in a very, large, scroll bar equipped field and the result would be very similar to that of a portal.
And you could use ExecuteSQL to generate a return separated list of Primary Key values and then a relationship to the layout's table occurrence could enable Go To Related Records to pull up a found set of records matching that list.
Retrieving data ...