This topic is locked

add data (one form) to multiple tables

8/31/2007 8:46:20 PM
PHPRunner General questions
A
azlo author

i noticed that phprunner can show different tables and you can add and edit data. well i have some data that has what you call a master-detail relationship. whe i edit a record, how can i have it edit the properties of the "linked" table at the same time? it seems that the field dissapears completely and i cant change it also. here is an example
po table:
Po_id, Notes, Amount
then i have a hardware table that has a key linked
Po_id, Serial_number, Name
so when i edit the Po table i want to be able to edit the contents of the hardware table at the same time that is linked. i hope this makes sense.
i prettty much want to figure out how to edit multiple tables from one form without custom code. please if someone could help me i would appreciate it.
azlo

Sergey Kornilov admin 9/1/2007

Without writing custom code you won't be able to update more than one table at once.
I would suggest to use BeforeEdit/BeforeAdd events to update data in the linked table.