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.