2. PHPRunner General questions
  3. [SOLVED] which query?
This topic is locked
[SOLVED]

which query?

 		5/18/2021 7:48:17 AM
PHPRunner General questions
I
 I author

**I have two tables
1 associations with the fields department no, department
2 members table with the fields name, department number, amount

I would like to see the following table:

the names of the members and the amount per association

grouped by association**

can anyone help me create a query?
HJB 5/18/2021

Report Totals and Layout
Citing excerpt:
Displaying lookup values in reports
If you need to display a value from a lookup table instead of the ID on the Report page, you have two options:

  1. Modify the SQL query to include the fields from joined tables.
  2. Enable the report search page, proceed to the Page Designer or Editor screen, open the Search page, double-click the field and turn it into a Lookup Wizard on the Edit as tab.
    Either option allows you to display values from another table on the Report page (i.e., Customer Name instead of Customer ID).
    unquote
    ... for inspiration purposes only ...
I
 		I author 5/18/2021

Tanks for this usefull info