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

[chriscorbett]

I think I'm good. On this question anyway!

Many thanks.

[Abhinay Erra]

Glad you got your question answered. Can you please mark my response as correct so that others who have same question can find the answer quickly.

If you are viewing this from the community inbox you will not see the correct answer button. Please open the thread directly, then you should see a Correct Answer button with red star.

[geoffcox]

What is in the resulting choice list? If your field is a reference to u_sar_roles, your reference qualifier can just be "u_requested_system=current.u_requested_system". This assumes that u_sar_roles has a column called u_requested_system whose value can match current.u_requested_system, whether they are both either strings, or sys_ids (if they are themselves reference fields).

Perhaps you should copy a paste a list view of your u_sar_roles table.

[geoffcox]

On the other hand and if your field is really just a choice list, then you don't need a reference qualifier. You just have a dependency which you can define as part of the dictionary information about your choice list.

[Abhinay Erra]

FYI: Reference fields can be made into a choice list, just by selecting Drop down without none in the choice list specification.