How to populate list field values into reference field.

[Rani11]

Hi All,

I have a required like. List field values into reference field.

In cmn_location table we have Type field it is list field. I wanted to use that list field into one my catalog item reference field.

OOB Table : Location you can see Type field its having Store and few more values. I wants to populate the same values into my catalog item reference variable. I tried it but somehow its not showing ..Is any one having any idea. how to do that.

It will be very helpful if i get some clue.

[Harsh Vardhan]

your reference variable is referring to same table where type field is referring ?

make sure table should be same . can you paste the script which you tried and not working ?

[Rani11]

Type field is referring to sys_user table .

And the reference variable is referring to cmn_location.

I tried like creating "Lookup Select "box variable and in the reference used cmn_location table and in Lookup value/Label field used this "Type" field. And given reference qualifier.