How to use same choices on two different fields on tables not related?

[Karina13]

I have two list fields on two different forms/tables not related (rm_release and sys_atf_test). I have a requirement to use the same choices in both fields, the choices are on the sys_choice table. I have tried using a Client Script to add the options, and that works for field type “choice” fields but not for “list” and I need to be able to choose multiple choices. Any ideas?

[Brad Bowman]

Hi Karina,

You can just set the Reference of both Lists to the Choice table, then add the Reference qual condition that identifies the records that you want to see - probably they all have a common Element and Table?

[Karina13]

Thank you for your reply. 

When I try to do that it is not possible to set the choice table as the reference? The table is not available. But it seems like you were able to do that?

[Brad Bowman]

I think out of the box there was a reference qualifier on the Reference field to exclude this for some reason.  So right-click on the Reference field on the Reference Specification tab, and choose Configure Dictionary. Look for a Reference qual condition on the Reference Specification tab of this Dictionary Entry and remove the sys_choice one.

[Karina13]

Thank you.

Well the question is why this reference qualifier is there in the first place?

I have tried to search on this topic and I am afraid that removing this could cause some issues... but I am not sure..