How can I populate a choice list with values taken from a table?

[pallabi]

I want to populate a choice list by taking values from a field in a table.I don't want to create dependent fields.

[NeilH2]

Hi Palabi

Create the field as a string field.

Open the dictionary entry for the field (advanced view)

Go to Choice List Specification

Set the choice to the one you want

Set the choice table to the table you want

Choose the field you want to display in your field

Save the dictionary entry.

Your done

[Renu3]

Hello Neil,

Thank you for this solution.This seems to work in my case.However would the same work if the data is huge say which gets updated every day?

In that case do we have to write a script or the same method works?

I am trying to populate a drop down from the incident table with a field called choice.So this choice field gets updated every now and then and has thousands of record in it.

Please find my work attached below.

Pic 1:Settings in advance field

Pic 2:How the choice field looks with limited data.

Please let me know.

Thank you in advance.