Extending Choice Field values from another table

priyabalukt
Tera Contributor

I have this scenario where I have two tables, master and base. Master table has three choice fields, (Field 1 - 1 choice; Filed 2 - 5 choices; Field 3 - 12 choice values being dependent on Field 2). I have similar three fields in the Base table and would want to extend the values from master table. How do I achieve this -> Reference qualifier or any other logic

1 REPLY 1

Mark Manders
Mega Patron

If it's two different fields, you will have to create the choices. Choices are stored in the sys_choice table and only come out for the field they are for. If the base table is extended from the master table, the field should already be available, including the choices. The only other possibility is to make the base field a choice field, referencing the sys_choice table with conditions of the other table. 
Easiest way is to just use the extended field, but I don't know how it has been set up.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark