Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-22-2022 11:35 PM
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-23-2022 03:46 AM
A reference field must have a display value and as the docs indicate if no field is set to display = true, the platform checks for other values.
Reference fields look for the display value in the following order:
- A field with display=true in the system dictionary on the lowest sub-table for extended tables.
- A field with display=true in the system dictionary on the parent table.
- A field named name or u_name.
- The Created on field of the referenced record.
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-14-2023 06:59 AM
Hello @Tony Chatfield1 ,
I can't use 'display=true' for other reasons, so I have to figure out a way to use "user_name" instead of "name" as a key reference in the users table.
Is there another option to set a reference key fields besides display=true?
Thanks. 😊