Reference Qualifier from field value in current record

[chriscorbett]

Hello All -

I am trying to create a reference qualifier that populates a choice list from a table based on the value of a field in the current record.

The current record has a field called u_requested_system. In a second table, I have a field u_system_name and some other fields like role, status, etc. My goal is to populate a field called u_role on the current record with the roles listed in the second table based on the shared system names.

I currently have it set up like this:

u_role is a reference field to a table u_sar_roles.

My reference qualifier I set up where System Name is current.u_requested_system

I have three record in my Roles table that should display but it is pulling nothing.

I would appreciate any ideas on how to change this.

Thanks!

Chris

[Abhinay Erra]

Chris,

  I am sorry, it is a bit confusing. can you provide few screenshots?

[Abhinay Erra]

Is "u_requested_system" a reference field to the second table?

[Mujtaba Amin Bh]

Share a screen shot of your reference qualifier.

[chriscorbett]

Sure.

I want to populate the Role field of the current record

with values from a second table based on what is selected in the System Requested field of the current record:

My Roles table looks like this

and my attempt at a qualifier: