Limit Child Records in Picker
I have a Child Request Record and an Approver Parent Record and each approver is assigned to an Approval group. I need to be able to limit the Picker in the Child record based on the Group selected. I tried using dynamic form rules to display a Section based on the Group and a filter report based on the group for the record, but it gets confused because it's the same field name in each section. I thought about Report links, but that work in the opposite direction. I also tried creating a Text Multiple choice field that grabs the selections from another table, but that won't list the names and does not appear as well to be able to limit by that group. Bottom line I just want to limit the list of approvers based on the Group selected in the child record. Any ideas would be appreciated, but I am not a programmer so needs to be something I can do with native Quickbase functions. TIA
------------------------------
Julie Meeker
------------------------------