I need display values from two list collectors to show in another reference field

[Vinuthna Ammana]

In a catalog form, I have two list collector field: "New Users" and "Old Users" which reference to 'sys_user' table.
I have another field - contact which is only reference to the User table but I only want the users selected in "New Users" and "Old Users" to show for this field,
I think I should use Onchange client script but do not know how to achieve it?

[Vinuthna Ammana]

changed to 

javascript: 'sys_idIN' + current.variables.new_users_to_be_members.toString() + ',' + current.variables.Users_to_be_members.toString();

It is working now 

[Ankur Bawiskar]

@Vinuthna Ammana 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Vinuthna Ammana 

Glad to know that my response worked.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Vinuthna Ammana 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Bert_c1]

A Reference field will only hold a single value, See:

DatabaseFieldTypes.html

Look at the definitions of the three fields and the max lengths for those.