Editing 2 tables from a single Edit page

This topic is locked

Editing 2 tables from a single Edit page	2/9/2008 5:29:36 AM
PHPRunner General questions
S slodigia_lem author Hello, I would need some guidance in adding some fields into the Edit page, even if these fields are not present in the schema of the table that has generated the Edit page, the objective is save the addtiional fields into a another table, therefoe the extra fields has to be passed into the &$values array to be used in the AfterEdit callback. Any help would be great!


A	alang 2/10/2008
	One way is to add dummy fields in your SQL statement: SELECT field1, ... 'DUMMY' AS DummyField1, .. FROM etc PHPR will add extra rows for these fields in the next tabs so you can select whether they show on list page etc. You will have to make sure to UNSET the dummy fields before record is added or edited in the database otherwise you will get an error.