Displaying sql query result instead of table content

Classic Servoy
1

Hi all, i’m very newby to this amazing software, but before moving all my filemaker solutions to this framework, one more question came to my mind.

I was wondering if it’s possible to use the result from a query has a found set and use it to fill a form instead of a table content.

That way I could build a query that would put together data from many tables and working with these as if they were only comming from one table.

Maybe with a SQL Views?

Thanks anyway for your help

2

Yes, you can use views for that. You can base your forms on a view then.