2. PHPRunner General questions
  3. One master table, with TWO child tables?
This topic is locked

One master table, with TWO child tables?

 		4/9/2007 9:38:28 AM
PHPRunner General questions
D
 dani author

Hello
I was wondering if PHPRunner would help me to setup a system to work with one master table "ORDERS" (orderId,date, customer, status), one child table "ORDERDETAILS" (orderID,product,quantity) and "ORDERCOMMUNICATIONS" (orderId,from,to,message) to keep track of messages related to that particular order.
In the order list display, I'd like to have the two links, one to the details list and one to the communications list.
Is this feasible with minimal manual code modifications?
Thanks
Dani
T
 		thesofa 4/9/2007

select 'orderdetails' in step 3 and set the 'orders' table as the master.

then select 'ordercommunications' as the table to deal with and set 'orders as the master.

build the pages, and I think you will find you have 2 links on the orders page.

HTH