Hi everyone,
I’m hoping to get some guidance on an issue I’m running into.
I’ve built a custom application with several table forms and record producers. I have a parent table that extends the Task table, and from there I created multiple child tables—one for each form that extend from my parent table. lets call my parent table DO Case Table,
In one of my record producers, I need a reference field to filter its available records based on the value selected in another field. For example:
If Case Type = EE, the Case Lookup field should only show EE records.
If Case Type = BB, it should only show BB records, and so on.
I need this filtering to work both in the record producer and on the table form itself.
I’ve tried using dictionary overrides and reference qualifiers, but I haven’t been able to get the filtering to work. Right now, my Case Type field has these options (EE, BB, CC)but the Case Lookup field— which references the parent table (DO Case table)—still displays all records instead of filtering by the selected Case Type.
Has anyone implemented something similar or can point me in the right direction?
