Grid Edit page not showing all tables fields

venkatesh · Post by **venkatesh** » Sat Oct 05, 2013 8:36 pm

I have prepared a custom view "Myteam" using 3 tables. Myteam list page shows all 3 tables fields as I expected. I made field setup as one table fileds are editable and other two table fields are readonly. But Myteamlist.php?a=gridedit showing only one table fields which are editable. I want to show all 3 tables fields in grid edit page. PHPMaker10.

mobhar · Post by **mobhar** » Mon Oct 07, 2013 9:47 am

Then you have to switch those 2 tables from readonly to editable so that all the tables fields will be displayed in Grid Edit page.

danielc · Post by **danielc** » Mon Oct 07, 2013 10:15 am

Try not to use custom view but use database view to try. However, you can not update more than one table through view.

You have to save the variables in Row_Updating server event. Then, update other table by executing ew_Execute("UPDATE table2 SET XXX").

venkatesh · Post by **venkatesh** » Mon Oct 07, 2013 12:12 pm

yes database view supports my requirement. But I did it in v8 and after migrated to v10 the problem occurs. Any way I go head with database view.