Setting Reference Field Values from Another Value of the Same Table

[Wasdom_Kung]

Hello,

I currently have a reference field that pulls information from a table - as you can see below there are multiple entries for A053501, but the second and third columns of this table will have differing information (This is fine).

When a user selects a value, say row 1 from above, the field 'All associated trays' should populate all of the entries with the same ID (A053501) just so the user can cross-check their selection.

I've read multiple threads about using javascript as a reference qualifier:

javascript:"u_all_associated_trays=" + current.u_unique_tray_id

and also using / setting dependent fields (I haven't been able to find this though)

Any help is appreciated.

TRANSLATE with x

English

Arabic	Hebrew	Polish
Bulgarian	Hindi	Portuguese
Catalan	Hmong Daw	Romanian
Chinese Simplified	Hungarian	Russian
Chinese Traditional	Indonesian	Slovak
Czech	Italian	Slovenian
Danish	Japanese	Spanish
Dutch	Klingon	Swedish
English	Korean	Thai
Estonian	Latvian	Turkish
Finnish	Lithuanian	Ukrainian
French	Malay	Urdu
German	Maltese	Vietnamese
Greek	Norwegian	Welsh
Haitian Creole	Persian

TRANSLATE with

COPY THE URL BELOW

Back

EMBED THE SNIPPET BELOW IN YOUR SITE

Enable collaborative features and customize widget: Bing Webmaster Portal

Back

[Anil Lande]

What is the name of 1st column?

Thanks,

Anil Lande

[Wasdom_Kung]

Ah, I have corrected my previous reply, here is the table:

It is u_tray_id

TRANSLATE with x

English

Arabic	Hebrew	Polish
Bulgarian	Hindi	Portuguese
Catalan	Hmong Daw	Romanian
Chinese Simplified	Hungarian	Russian
Chinese Traditional	Indonesian	Slovak
Czech	Italian	Slovenian
Danish	Japanese	Spanish
Dutch	Klingon	Swedish
English	Korean	Thai
Estonian	Latvian	Turkish
Finnish	Lithuanian	Ukrainian
French	Malay	Urdu
German	Maltese	Vietnamese
Greek	Norwegian	Welsh
Haitian Creole	Persian

TRANSLATE with

COPY THE URL BELOW

Back

EMBED THE SNIPPET BELOW IN YOUR SITE

Enable collaborative features and customize widget: Bing Webmaster Portal

Back

[Anil Lande]

Then your reference qualifier would be:

javascript:"u_tray_id=" + current.variables.u_unique_tray_id.u_tray_id.toString();

Thanks,
Anil Lande

[Saurav11]

Hello,

Looks like you are using a catalog item:-

So use the below reference qualifier:-

javascript:"u_all_associated_trays=" + current.variables.u_unique_tray_id

Please mark answer correct/helpful based on impact.

[Wasdom_Kung · Accepted solution]

This was actually re-designed to be achieved using a script include and by changing the field from a reference to a unique value field (This has a big performance impact considering how many values we are using - over 30k - but it will do for the time being)