How to create a dynamic choice list from data in column of another table?

[Krishna119]

I need to display a choice list on table A with values in column x of table B. How to configure this? I'm also fine if it is some other component, if not choice list but need the dynamic list.

Note: This is not about "reusing" a choice list defined on column x of table B. I want to use the data that is present in column x.

I could use a 'Reference' field, but my requirement is also to have a "--None--" choice as well, so looking for "Choice" field

[Pradeep Sharma]

Hi Krishna,

You can use reference qualifier to get dynamic choice value from the target table. Please refer below link on how to convert reference field to a dynamic choice list via attributes.

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/field-administrat...

- Pradeep Sharma

[Anil Shewale]

Hi

refer the following thread it gives different scenarios to make choice filed. it might help you. 

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/field-administrat...

https://community.servicenow.com/community?id=community_question&sys_id=f3a703e9db1cdbc01dcaf3231f96...

If it help mark helpful or correct 

Thanks and regards

Anil

[Ankur Bawiskar]

Hi Krishna,

So in column x of table B you need to show choice list of table A

You can do this in below steps

1) configure the dictionary for the column x on table B

2) Select the type as choice list

3) select Drop down with None

Select advanced view

4) Under choice list specification

-> select the choice table A

-> select the choice field from table A

it would start showing those choices in column x of table B

Example below:

I created choice field on incident and it will show the choice values along with none from the category choice field of change_request table

Regards
Ankur