2. PHPRunner General questions
  3. Sub reports / forms
This topic is locked

Sub reports / forms

 		3/13/2009 7:24:28 AM
PHPRunner General questions
S
 smalltime author

I am trying to use phprunner to switch from MS Access, to a PHP / MySql solution. All is going well, except I can't figure out how to have a subform/report. For instance, if we imagine you have an InvoiceMaster table, and an InvoiceItems table, which is a one to many relationship, how do I go about creating a webpage that for each invoice shows all connected invoice items ~ is this something I am able to do with in Phprunner, or do I need to create an SQL query and base a page on that?
Many thanks
Sorry forgot ~ I'm using PHP runner 5.0
J
 		Jane 3/13/2009

Hi,
to create report based on the master and detail tables create new report on the Datasource tables tab and then join master and detail tables on theEditor SQL query tab.
S
 		smalltime author 3/13/2009

Thanks for the info, I'll give that a try.