INPUT() selection from REF values

[alphacp]

As is my nature, I read things in these forums and quickly go try something then often clean up a while later only to find that I then forget how I did something. I am sure I did this but now cannot recreate it …

I have a column and I am using a behavior to set the value of that column using INPUT(). I thought I had managed to find a way to produce a drop down list as the INPUT using a list of Project Names from another table. The column in question is a REF to that Project table.

Is this possible? I thought it was.

[Suvrutt_Gurjar · Accepted solution]

If the understanding of your question is correct , yes, it is possible.

Please simply define the INPUT() function in the action on that reference column and the entire list of available options is shown.

In the action below “Product ID” is the reference column in the “Order Details” view that references the Products table.

The input action is simply defined as
INPUT(“Product ID”, “Apple”)

The result is as shown below. The products list pops with an initial value and expands to include all products from the referenced table.

[alphacp]

Many thanks. That was indeed the answer