How to filter select box selection base on another field selected option? Catalog Item Form

[Gian1]

We have catalog item that has the following field 

Look up select box field called Campus - Which references the u_campus field in the table cmn_location 

and

Reference field called Exam Room Location - Which references the cmn_location

What we want is when a user Selects a campus for example "City Campus" The exam room location selection should only show the rooms from the city campus and if they change to North Campus the exam room location selections should only show rooms from north campus.

I tried to do an onchange script that did not work.

Any help will be much appreciated. Thank you

[Danish Bhairag2]

Hi @Gian1 ,

Kindly remove &colon from the advanced reference qualifier. It should work.

Please mark @Vishal Birajdar  answer correct if it helps you resolve ur query.

Thanks,

Danish

[Gian1]

Hi Danish,

Still did not work. It's not refreshing the list. It's still showing all the room location from all campuses.

[Vishal Birajdar · Accepted solution]

Hi @Gian1 

Ok got it...

reference qualifier should be highlighted in below screenshot

Actually , colon (:) will get converted here in community text editor.

[Gian1]

Thanks heaps. This worked