A record list that draws from multiple tables?

Classic Servoy
1

This couldn’t be done in Filemaker, but maybe in Servoy?

I’d like to allow the user to type in a search field, say “acme”, and search several tables for that value.

So it might search the customers table and the vendors table and return one result from each

Acme Importers Customer
Acme Consulting Vendor

And then you click on the record and it takes you to the correct screen.

Any way to do something like this using the SQL capabilities of Servoy?

PS I know you can do this in FM by importing records into a temp table… I’m looking for a faster, more elegant solution.

2

In Servoy it’s WAY more elegant!

Just perform your find(s) via SQL statements, and then you can loop through the results and show them in HTML format.

Then you can use an anchor link around each of the results to trigger a method to show that specific record.

Hope this helps.