need to populate reference field values based on previous select box options

[Sateesh11]

Hi All,

we have two fields (1. Location--->select Box with three values 105 West,33 NYA & Mission Bay)

2. Seating Assignment (Reference Field from custom table(u_seating).

my requirement is, based on select box value, reference field values should be populated)

ex: if i select 105West from select box, reference field should display 1, 2 & 3 only

if i select 33 NYA from select box, reference field should display 11, 12 & 13 only

if i select 105West from select box, reference field should display 21, 2 2& 23 only

attached the screen shot for fields & table structure,

[Sandeep Rajput]

@Sateesh11 You need to have advanced reference qualifier on your Seating Assignment field as follows. This is applicable if you are setting the reference qualifier on the platform view.

Use the following reference qualifier if you are using it on the reference variable on a catalog item/record producer.

Please mark my response helpful and accepted solution if it addresses your question.

[Sateesh11]

Hi Sandeep,

unfortunately, not working for me.

after selecting location, getting blank screen, attached screen shot

Thanks,

Sateesh

[Sandeep Rajput]

@Sateesh11 Could you confirm the following.

1. Name of the location variable on Catalog item form. Please share the screenshot of Question and Type specification tabs of Location variable.

2. Name of the location field on u_seating table

[Sateesh11]

Screen shot attached