2. PHPRunner General questions
  3. More Tables in one page
This topic is locked

More Tables in one page

 		12/19/2007 2:18:25 AM
PHPRunner General questions
S
 swanside author

Hello all, What a great program, did a work database in a few mins, but now, i would like some help please.
I have four tables, Customer, Job, Labour and Material. I have designed the program so on selecing a Job, it displays the job iwth links to display the material, labour and customer.
I click on the labour link, and it shows the labour for the particular job, along with the job, but, how an I get it to display all the information on the same page, so it will show the Job, the Labour and the material?
Thanks.

Paul.
J
 		Jane 12/19/2007

Paul,
you can create custom view on the Datasource tables tab and join these tables on the Edit SQL query tab.

Here is a sample:

select Job.field1,

Job.field2,

Labour.field3,

Material.field4

from Job inner join Labour

on (Job.JobID=Labour.JobID)

inner join Material

on Job.JobID=Material.JobID
S
 		swanside author 12/19/2007

Paul,

you can create custom view on the Datasource tables tab and join these tables on the Edit SQL query tab.

Here is a sample:


Wow, that looks complicated, good job I have the christmas holidays to have a go.
Thanks for your help

Paul.
S
 		swanside author 12/19/2007

Thanks Jane, WOrked a treat.