Share
ReportThis seems to be a straight forward arrangement but I just cannot make it work...
I have three entities - Skill Areas, Skill Groups and Staff Skills - preparing to setup a hierarchical arrangement so that when users create a Staff Skill record, user can first select a specific Skill Area and when user tab to the Skill Group field, only Skill Groups related to the selected Skill Area will be displayed for selection.
This setup runs fine on the Staff Skills main form.
But when I adapt this arrangement to an editable grid, the Skill Area field works fine...
Yet the Skill Group field not - the magnifying glass icon looks like disabled / grayed out...
Once I uncheck "Only show records where" setting for the Skill Group Lookup field, the field immediately work - but showing all Skill Groups not related to the selected Skill Area of course.
I wonder if there is some restriction for this OOB editable grid.
Has anyone experienced such situation before?
Can anyone share some thought on how to work on this?
Thanks
*This post is locked for comments
All responses (
Answers (
291,253
