2. PHPRunner General questions
  3. Edit record inline, nested within another records edit page and link
This topic is locked

Edit record inline, nested within another records edit page and link

 		2/28/2009 6:37:17 AM
PHPRunner General questions
S
 smauster author

Hello,
I've recently downloaded PHPRunner to evaluate it for a project. It appears to be a pretty great program which automates what would normally be a fairly lengthy learning and development cycle. I'm very happy with it so far, but there are a few niggly things I would love some advice on before forking out (what is to me) a fairly large wad of cash to purchase it.
So, I've completed a little browsing on the forums, and found a few topics which were close, but not close enough that it helped me resolve my question. My question is;
I have two tables, one is called INVOICE and the other is called LINE. INVOICE and LINE have a one-to-many relationship.
Lets assume that INVOICE contains:

Invoice_ID, To, Issue Date, Due_Date, and Total.

And lets assume LINE contains:

Invoice_ID, Line_ID, Description, Quantity, Unit_Price and Amount.
When I create a new INVOICE I want to be able to add multiple LINE records in an inline fashion. And when I add a LINE it should automatically be linked to the INVOICE, so the Invoice_ID field in the LINE table (which is not visible) will be populated with the INVOICE_ID of the new INVOICE I am currently creating.
I don't think PHPRunner actually gives me this out of the box, but would it be possible to achieve a result like the example above with minimal fuss?
I would appreciate any comments to this topic.
Thanks for your time,
Xander
kujox 2/28/2009

I have two tables, one is called INVOICE and the other is called LINE. INVOICE and LINE have a one-to-many relationship.

Lets assume that INVOICE contains:

Invoice_ID, To, Issue Date, Due_Date, and Total.

And lets assume LINE contains:

Invoice_ID, Line_ID, Description, Quantity, Unit_Price and Amount.
When I create a new INVOICE I want to be able to add multiple LINE records in an inline fashion. And when I add a LINE it should automatically be linked to the INVOICE, so the Invoice_ID field in the LINE table (which is not visible) will be populated with the INVOICE_ID of the new INVOICE I am currently creating.


Yes it does this out of the box, i've got invoices, sales orders, purchase orders, purchase invoices etc. all with detail lines, you just make a relationship link in the datasource tables page, just drag a link from one table to another and the relationship screen comes up, double click on the line to edit the relationship
S
 		smauster author 2/28/2009

Yes it does this out of the box, i've got invoices, sales orders, purchase orders, purchase invoices etc. all with detail lines, you just make a relationship link in the datasource tables page, just drag a link from one table to another and the relationship screen comes up, double click on the line to edit the relationship


Hi Kujox,
Thanks for the reply. I followed your instructions but still haven't managed to get this to work.
What I did was, modified the relationship to make sure it looked okay. I changed the "Preview detail records in popup" to "Preview detail records in inline"


I then built my project. However it doesn't look like I can view or add invoice lines from the invoice add page.
J
 		Jane 3/2/2009

Hi,
PHPRunner doesn't support updating multiple tables (master and detail) on one page.

I recommend you to add new master record and then add detail records on the list page directly (Inline Add option).