Taking sys_choice table as reference table in a new field in scoped application

kaushiki berter
Tera Expert

‎04-08-2024 07:23 AM

Hi, I have a requirement to add sys_choice table as reference field in a new field in scoped application table.

However, in reference specification section I cannot find sys_choice table. Kindly help me in resolving this.

0 Helpfuls
  • 647 Views
1 REPLY 1

Community Alums
Not applicable

‎04-08-2024 07:45 AM

Hi @kaushiki berter ,

Unfortunately Not a Good Idea!!

The Choice table should not be used as the reference table for a Reference type field. Reference fields store the sys_id of the corresponding record in the reference table and show the specified display value. For example: the caller_id field stores the sys_id of a record from the user table and displays the corresponding name value. This presents a problem when using the sys_choice table, because existing records are deleted and replaced when choices are modified. This causes a new sys_id to be generated for each record in the choice list. So the sys_id stored in the Reference field is no longer a valid value and the reference is broken.