Table Reference Question: How to Set the Ref Column to Automatically Select the Row Instead of Having Choices

[Tony_Insua]

I have a table with a column that references another table. See below. How can I set the reference column so that it selects the one row label automatically, without having to CLICK and PICK?

The PROFILE table with the PROFILEID has a security filter USEREMAIL()=EMAIL so that the user should only see their own profile.

Default No Selection of PROFILEID

:

CLICK AND PICK (which I want to avoid). I don’t want to select NEW or the Profile - I just want it automatically set to the user profile.