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.
User | Count |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |