how to create choices from table records?

[alvatindra]

I have a table xyz, there are records in that table.

Is there any option to get the values of one column of xyz table, as choices?

[akashsrm100]

Yeah Tindra

you can do you will have to defined in choice vwalue The table_name and column

Go to configure dictionary>advanced vie

Thanks

Akash sharma

SNOW developer

PS Hit like/Correct if helps

[alvatindra]

Hi Akash Sharma,

1.The table which I have created is not visible in the choice table drop down.

2.The field choice field is not present on dictionary entry form of Advanced view.But it is present in the form layout option(slush bucket).

3.The field which I want to create choices,is of reference type.

[Chuck Tomasi]

Hi Tindra,

In order to use choices from another table, the other table must have a choice field to choose from. Reference fields don't count in this case.

I created a new field on incident called u_computer and pointed it to a new table I created called u_my_computer. When u_my_computer had only a reference field, it did not show as an available table. When I put the Type (choice) field on the form, it still did not show. It was only when I add choices to the Type field that it allowed me to select the table name and my only choice filed (Type.)

This is all controlled through a script include called: DictionaryChoiceTables where you can see the query it makes to generate those lists.

[MReddy]

New version it's not showing as choice table only showing as choice under list specifications