I need to create a universal search in a WinForms app that can search across multiple tables for certain columns and give results in categorized format.
So if I type "James", I would get:
- Clients
James Taylor
James Brown
-Suppliers
Jammie James
- Invoices
Nro 11425 James
The dashed titles would be category or in this case table.
A theoretical or actual example will go a long way!