2. PHPRunner General questions
  3. Limiting the child rows
This topic is locked

Limiting the child rows

 		7/22/2011 8:07:13 AM
PHPRunner General questions
P
 pim author

I have a master table called ''.
'[color="#FF0000"]OrderDetails' also has a child table called ''.
A specific field of '[color="#FF0000"]OrderDetails' is "".
Now, if at this specific field "[color="#9ACD32"]Quantity" a value is entered in its form like for example '10', is it then possible that only and maximum 10 rows in it's child table RentalCameras must be filled out.
I assume that this is an event which has to be added at OrderDetails?
C
 		cgphp 7/22/2011

Check the AfterTableInit event (http://xlinesoft.com/phprunner/docs/after_table_initialized.htm) or the Custom Query event (http://xlinesoft.com/phprunner/docs/custom_query.htm)
P
 		pim author 7/22/2011

Thank you for your quick answer. However, I'm new to PhpRunner, and do not understand how I should implement the events of your given links.
From link in costum_query.htm, I understand that I should build an event that creates a query. The data displayed in the child will then depend on the data that is inserted in a masters table.
From link after_table_initialized.htm I understand that I could set a default of records.
But I do not want a default set of records, nor a fixed query. The query can't be fixed, because the master table 'OrderDetails" has more then 1 child tables.
Could you please help me further? Thank you so much in advance!
C
 		cgphp 7/22/2011

Please, post a demo link, so I can exactly see what you mean.
P
 		pim author 7/22/2011

Just a question, will this demo be visible to everybody or only to those I invite?
C
 		cgphp 7/22/2011

Send me a pm with the demo link.