This topic is locked

As I get into a page_list records grouped by a field

12/4/2007 7:15:33 AM
PHPRunner General questions
J
jesusmanuel author

As I get into a page_list records grouped by a field:
Table 1

Reg: autoincrement

Numid: int (11)

Name: char (50)
Table 2

Reg2 autoincrement

Numid: int (11)

Process: char (250)
And I wish that the page appears list
View edit nombre1 process1 of nombre1

View edit process2 of nombre1

View edit process3 of nombre1

View edit nombre2 process1 of nombre2

...

...

...
Thanks

J
Jane 12/4/2007

Hi,
unfortunately you can't join master and detail records on one list page automatically.
As workaround you can do the following:

  1. create new report on the Datasource tables tab,
  2. edit SQL query for this report on the Edit SQL query and and join master and detail tables,
  3. modify report on the Visual Editor tab and add edit/view links manually.