This topic is locked

multi table view edit problem

1/6/2014 9:37:24 PM
PHPRunner General questions
A
Allan Hanlon author

Over the weekend I was able to create all of the "views" in mysql to match my old access system. However, since the view includes several linked tables, I can not edit from the table view. Is there a way around this? Can we have the edit button open a form linked to the actual tables? Hopefully I am explaining this properly.

Sergey Kornilov admin 1/6/2014

In SQL world you can only update one table at the time. If your view is built on several linked tables you will need to prevent PHPRunner from updating linked tables. This being done by unsetting linked fields in BeforeAdd/BeforeEdit events.
If you still need to update the linked table this can be done manually in the same event. Check Example #1 here:

http://xlinesoft.com/phprunner/docs/update_multiple_tables.htm