Reference Field That remove duplicates & getting value of building.

[win b]

Hi can you help me on this task. The key on the task is to use a table (alm_asset) wherein im going to use the Reference as Type to get the value of building in the alm_asset table. But the needed requirements is dropdown should only show the building names and no duplicate entries in choices.

in the advance qualifier i want to get only the values of he building field but i failed to get it.

here is what i want to get but in my dropdown it only shows the name of device

also if its possible upon selecting the location i can retrieve the serial numbers of the selected location on another field?

[win b · Accepted solution]

@RaghavSh I got an update on this. I completely done this using MRVS here is what i did. 
In my MRVS i inserted my Building Location and Asset Serial Number and both of them using Lookup SelecBox. unfortunately when it comes on Variable Set OnSubmit Catalog Client Script im having error on JSON.parse. But on my OnSubmit Catalog Item its currently fine.

here is my code in Variable Set OnSubmit that have an error. Which supposed to be checker upon adding rows in MRVS forbidding to Add a duplicate entry 

But on my Catalog Item OnSubmit its already working. 

i needed help on the Variable Set OnSubmit only for now for avoiding adding duplicate

[win b]

@RaghavSh It doesnt work on my end.

all the options in my serial number appear and the name of device is showing. wherein the requirements needed to display is the serial number only upon selecting and selected

[RaghavSh]

@win b your requirement is not clear

[win b]

@RaghavSh What i mean in my requirement was. On my Building location field which is the 1st one. Its already working upon selecting the Building location using the type: Lookup Select Box. But on my 2nd field which is the Serial Number upon selecting a location. It supposed to display all the serial numbers based on what location i selected. But whats happening right now is that on the serial number it displays the name only not the actual serial number.

For example.
I selected a location "Avatar"

in the Serial Number field i supposed to select and see the serial numbers of Avatar but whats happening is device name is the one thats showing not the serial number

same goes when selecting it displays the device name instead of serial number

[RaghavSh]

List collector and reference fields cannot show anything except from the display name, you need a lookup select box for that.

Its not possible with reference field and list collector.

[win b]

if i used Lookup Select Box on the Building Location. and i used List Collector on the Serial Number. will it work?