Choice list table selection

[Michael Searle]

Screenshot for reference included below.

When creating a new column in a table I've noticed that some types appear to allow the use of a choice list. In the example below I choose String as the type for the column. Scrolling down the form I see a tab for Choice List Specification. The annotation in the section states "In the Advanced view you can select the Choice table ..." This suggests that I can choose to use something other than the sys_choice table to create a choice list for this column. In looking at the tables available in the dropdown I see only a limited or filtered list of tables. In my case, none of the tables come from my custom application. 

What must I do to the table that I want to use as the choice list to include it in the list of tables available in the dropdown?

[Sandeep Rajput]

@Michael Searle Please check your table configuration and see if it is accessible from all the application scopes.

[Josh Virelli]

I realize this is months later, but I wanted to clear this up for future folks. The expectation here is that you are pointing to a Choice field on another table and utilizing the same Choices (sys_choice) as that Choice field. The Choice Table field will only populate with Tables that have a Choice field on them. You can reference the DictionaryChoiceTables Script Include to see this in action.

The benefit here is coupling multiple Choice fields to use the same Choices so in the future, if you make a change, it would apply in all instances of the Choice fields pointed to those Choices.

If you're looking to have this field point to a record on another table, you would use a Reference type field.

Thanks,
Josh