To perform a global search in all tables in the database I created, following your advice a specific SQL query that includes all the tables.
Now the search finds the requested data but can not direct address it.
The database has 10 tables, the main is "COMPANY" that has as a table detail "ADDRESS" which in turn has a table detail "CONTACT" other tables are support to these three tables for a range of common data.
Now if I do a "global search" to find an item in "CONTACT" the search is successful, but clicking on the found record the detail is different (redirect on COMPANY detail record).
If you do I search directly in "CONTACT" (now that I've discovered that what I want is a contact) and find it, by clicking on the record found I can see the details.
Is there an easy way to get the correct details on found record or is an undertaking from super experts?
Thanks