Search Multiple Tables and Return Categorised Results (eg. Customers, Vehicles, Invoices)

Hi All,

Had quick search of the forums and can’t seem to find anything on this so hoping someone might be able to point me in the right direction…

I’m wanting to have a search bar on a page which queries customers, vehicles and invoices for example, as you start typing in the search bar it will start giving results - that bits easy, here’s the tricky bit, I want it to split the results for each table query so that it shows a heading like this:

Customers

customer results from search (if any)

Vehicles

vehicle results from search (if any)

Invoices

invoice results from search (if any)

Has anyone successfully implemented a search bar like this in wappler before? If so, how did you approach it?

Thanks in advance
Ben