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 · Accepted solution]

put this in the reference qualifier section

javascript: "u_system_name="+current.u_system_requested;

[chriscorbett]

That worked... but why?

Also, what if u_system_requested were changed? the role field did not seem to update if I changed the value of System Requested.

[Abhinay Erra]

Chris,

    This is the syntax for using reference qualifiers by using javascript:

[chriscorbett]

I had not seen that before so that's why I asked.

[Abhinay Erra]

No worries, been there Let me know if there is anything else?