Multi Table Form

This topic is locked

Multi Table Form	6/17/2010 3:33:24 PM
PHPRunner General questions
M mpatten author Hi, I have three tables that I'm trying to do a new add record. Each table has a field that will match another field on the table for master and child references. Is it possible in phprunner to do an add record for three tables in one view? I've tried doing a custom view and mysql joins in mysql query builder then created an add page for that view. I get errors for all the fields that are in the 2 sub tables saying the fields are invalid. Is this possible or am I going to have to have three separate pages? Thanks, Morgan


	Sergey Kornilov admin 6/17/2010
	You'll need to implement BeforeAdd event for this view and add records to related tables manually. More info: http://xlinesoft.com/phprunner/docs/insert_a_record_into_another_table.htm http://xlinesoft.com/phprunner/docs/update_multiple_tables.htm