Options for options picker from different table

[mslourens]

Say I have a database with a table Products and a table Categories. The products table contains a relationship column with the categories table (one product to many categories). Is it possible to add an options picker to the products form using the rows in the categories table as options and store them in the relationship column of the products table?

[mjashanks]

Like this?

I setup as you described, and updated all the form fields on the Field Group. It added this by default.

[mslourens]

Clicking the Update form fields button did create a select with the correct fields as options, but when I tried to add an Options Picker, it did not list my column. What I needed was a Relationship picker instead of an Options Picker.