2. PHPRunner General questions
  3. [SOLVED] how to search in different tables?
This topic is locked
[SOLVED]

how to search in different tables?

1/21/2022 1:47:02 PM
PHPRunner General questions
J
 Jan author

Hi Forum,

I have built an application with phprunner, containing 4 tables.
table A
table B
table C
table D
These tables have different names. ( thousands )
If I want to look up a name, I can do that easily with the search function. But I have to find 4 different tables.
I would therefore like to make something that a name in an edit field will look up all 4 tables, and then show the name but also show from which table the name comes ...
How can I fix this? Suggestions always welcome. Thanks in advance
D
 		DealerModulesDevClub member 1/21/2022

Have you tried creating a dashboard and add 4 grids / lists table to the dashboard?

The header to the dashboard will contain a search and it should solve your issue.

For each of the lists in the dashboards, just turn on edit and view icons for each record.

Hope this helps.

Paul
J
 		Jan author 1/22/2022

works perfectly, thanks for the right tip!