How to create a drop down menu based on a field in a table?

[Ben67]

How to create a drop down menu based on a field in a table?

I have a table called "Build Lists" with a field name "Build Names". I want to create a drop down menu in my release table that will let a user select options from my "Build Name" fields. Can you advise on how to do this? I tried to add the "Choice" field type to the release form but it is asking me to create choices. I do not need to create choices. I want to be able to select choices that are currently in my Build Table.

[Michael Ritchie · Accepted solution]

Ben is this a single select or multiselect?

If single: use a reference field and once setup, configure the dictionary of this reference field, go to the choice list specifications tab, and choose one of the Dropdown options

If multiple: use a list type field. This will expose a slushbucket.

[Ben67]

Thank your sir! I was trying to create a single and your suggestion has worked.

Thanks,

Ben

[srevinU]

Hello, 

I'm facing the same issue,

I have set the sys_user table to the 'Reference' field in the 'reference specification' Tab in the Dictionary Entry.

I got the table right table, but when I select the name chosen, I would like to get the email and not only the name.

How could I process ?