2. PHPRunner General questions
  3. Adding data to master details table
This topic is locked

Adding data to master details table

 		8/20/2008 11:23:33 PM
PHPRunner General questions
E
 emsurban author

Is it possible to have a single page for adding master and details table.
Let say for example:
I have employees and task table..
If i want to add record to employee table, I can also add task record to this employee in the same page....
Thanks!
N
 		nix386 8/21/2008

I don't think you can but you can include the detail fields in the master table then insert these values into the detail table then record is added/updated?
Nick
J
 		Jane 8/21/2008

Hi,
PHPRunner doesn't support updating multiple tables on one page.

You can implement this manually using Before record updated/added events.
I.e. use something like this:

global $conn;

$sql = "update othertable set joinedfield=".$vales["joinedfield"]." ... ";

db_exec($sql,$conn);

unset($vales["joinedfield"]);