2. PHPRunner General questions
  3. [SOLVED]  Populate details table
This topic is locked
[SOLVED]

 Populate details table

 		5/21/2020 00:55:05
PHPRunner General questions
rdf author

Hi PHPR community,
How to populate a details table when the Add new button is clicked on the parent table.
FORMDETAIL table will have data from the CATEGORY and SUBCATEGORY table.
Much better if listing on the FORMDETAIL table will be organized as tab using the CATEGORY table name.
FORM parent

id

name

system_id
FORMDETAIL detail

id

form_id

category_id

subcategory_id
CATEGORY

id

name
SUBCATEGORY

id

name

category_id
N
 		Nir Frumer 5/21/2020

hi

on the tables tab, add all fields that you want 'auto populated' to the 'link fields' list,
hope it helps,
rdf author 5/21/2020



hi

on the tables tab, add all fields that you want 'auto populated' to the 'link fields' list,
hope it helps,


Hi Nir,
Thank you for your reply. I am not sure where in PHPR would that be. But, I am keep searching for it right now.
Can you show me a screenshot? Thank you again.
rdf author 5/22/2020

I think I got it.
I used the table->Add page->After record added event.
And, then utilized the following:

https://xlinesoft.com/phprunner/docs/db_select.htm

https://xlinesoft.com/phprunner/docs/db_insert.htm

https://xlinesoft.com/phprunner/docs/sql_variables.htm
I also utilized a while loop to insert multiple rows on another table.