I’ve an issue that I don’t know how to fix.
I’m using the latest 2018 build.3 tables
Table 1: services
Table 2: customers
Table 3: locationsLocation Table use an ID_customer field so I can relate one-to-many with Customers table. (Some Customers have many Location)Services table use ID_customer and ID_location, in the View Tag - Hyperlink - Prefix properties of this fields I insert a link so from the main Services List Table a user can click on the Customer name or on the Location name and access the View Page of this record (using target _blank).In my Services table list, the link that point to Customer view is like customerview.php?showdetail=services,locations&ID_customer=When the user click this is recorded as an Environment variable/filter.If I click EDIT on any Services record from the list page, Customer and Location are NOT editable and changed to the previous one clicked before.The problem is in the “showdetail=services” because if I remove the showdetail[…] part all works fine.How can I fix this?
Issue solved with a workaround.On the customer view page, on server events - global - view page - Page_Unload I put this line: unset($_SESSION[‘PROJECTNAME_TABLENAME_x_IDCUSTOMERNAME_SessionValue’]);
You must replace PROJECTNAME, TABLENAME and IDCUSTOMERNAME with your value.I hope this help.
The “showdetail=services” means showing services as a detail table and hence the current master table (customer) is effective, so you cannot change the customer ID.To reset you need to click the service table in the menu, the URL has parameter “cmd=resetall” to reset master/detail tables, e.g. “servicelist.php?cmd=resetall”.
i know that clicking on the menu fix this issue because the link have the cmd=resetall, but the link on field I use have target=_blank, so the user can simply close this new window and come back to the already opened list without select it from menu, this is why I need to reset in some way.The unset at the end of the view page fix the problem for me.