gridadd parent/filter not works

PHPMaker General Discussion (PHPMaker)
1

I have 2 select “dropdown list” field. (v2020.0.6)
Using grid-add: If i select one value from parent the child select is not populated.
Using add: im able to select an value from child after parent select
InlineAdd/gridAdd not works (child list shows “Please Select” and no data to show)
inlineEdit/gridEdit not works (child list shows “Please Select” and no data to show, it does not even show the existing value)Add/Edit works fine (child list is populated)

2

Your description is too brief to reproduce, can you post more:

  • CREATE TABLE statements for the main table and the lookup table
  • Edit Tag and Lookup Table Settings for the lookup field
3

Please note, since v2020, a “Lookup” permission was added and separated from the “List” permission (v2019 and earlier).So, double check the “Lookup” permission for the Lookup Table of your child dropdown, make sure it has been enabled for current user level from the generated User Level Permissions (userpriv.php) page.

4

im using only hardcoded admin.even if I had a permission table, the error is reported only on gridedit/inlinedit & gridadd/inlineadd and not on editpage/addpage.

5

Enable debug mode (Tools → Advanced Settings → Debug) and check the network response (F12 → Network) from lookup.

6

I am having the same problem, if I have a master table and I want to filter a field in a child table using lookup.If I use add master / detail by adding the parent record and the child records at the same time, the field options appear and I can select them; but if instead I first create the parent record and then I want to add the child records the values ​​of the select field appear empty.I use version 2020.0.6

7

Webmaster wrote:
Enable debug mode (Tools → Advanced Settings → Debug) and check the network response (F12 → Network) from lookup.

8

maybe is not working because child has primary key = 0?

9

having the same issue here
I have made a lookup table with the parent Filter option
I have not use any server Event code (Extra Coding)

It is working with the Add Page and Edit Page. And all the data are showing correctly.
But it does not work in Inline Edit, Inline Add, Grid Add, Grid Edit.

Webmaster wrote:

Enable debug mode (Tools → Advanced Settings → Debug) and check the network
response (F12 → Network) from lookup.

As I am new to programming unable to identify the error from F12.
Please kindly help .

10

First read: https://developers.google.com/web/tools/chrome-devtools/network/reference

  • Press F12 in Chrome
  • Go to the Network panel
  • Run your site until you see the problem
  • Check the HTTP request to the API in the Network panel, look for something like “index.php?action=lookup” in the left panel and check the Headers and Response in the right pane.
11

arbei wrote:

  • Check the HTTP request to the API in the Network panel, look for something like
    “index.php?action=lookup” in the left panel and check the Headers

On the F12 I did not find anything like action=lookup.
I check it after activating the debug.

If I don’t put the parent filter option then it is working
and if I put the parent filter in the child field then the child field does not show anything.

12

bui wrote:

On the F12 I did not find anything like action=lookup.
I check it after activating the debug.

Debug enabled or not, requests will be sent to the API when you do lookup. However, click Tools → Advanced Settings first, make sure “Use lookup cache” is disabled, otherwise caching is used if the number of options in the lookup table is not more than the specified limit, and then there is no need to send requests to API.