2. PHPRunner General questions
  3. Single page with multiple view, add and edit table
This topic is locked

Single page with multiple view, add and edit table

 		7/30/2022 3:10:37 AM
PHPRunner General questions
A
 Abu author

Is it possible to build a single page with multiple view, add and edit sections from different tables? And a single save button to update all these tables.

A
 		Abu author 7/30/2022

For this I have created a sql view, that include fields from several table. One of the field has been connected with a keyfield in one of the table for a master-detail relationship.

For the insert sql, I have tried both values from field or detail fields the outcome is the same
img alt

I was not able to capture any values into the table. The error as below.
img alt

Thank you in advance.

,
Sergey Kornilov admin 7/30/2022

I don't think that SQL View is a correct choice here. For this kind of functionality I would suggest using events and Database API:
DB::Update()
DB::Insert()