This topic is locked

How I list the table orders_details into the order

4/23/2008 12:46:04 PM
PHPRunner General questions
J
jesusmanuel author

hi
I´ve similar tables in livedemo4
How I list the table orders_details into the order,

I mean, for example I want to do:
table orders

code: 1

Name: Order 1

mail:a@b.com
table orders_details

code: 1.1

codigo_orders: 1

Name: order_detail 1.1
code: 1.2

codigo_orders: 1

Name: order_detail 1.2
Report orders Table

code: 1

Name: Order 1

orders_detail: 1.1 order_detail 1.1

1.2 order_detail 1.2

mail: a@b.com
Thanks

etc. ..

J
Jane 4/24/2008

Hi,
use report for this purpose.

Create report on the Datasource tables tab and join both tables on the Edit SQL query tab for this report. Combine all orders fields if needed and select it on the Report: Group fields tab.