Forcing data into a field

[david_ze]

Hi all,

Need your help on how to force data into a field.

I have two fiels 'Project_Number' and 'Project_Ref' which are not connected directly.

I would like to fill 'Project_Ref' field with the numbers I get when choosing the field  'Project_Number'.

'Project_Ref' contains the same data as 'Project_Number'.

It should be like this:

If I choose the numbers 1,7 and 55 from field  'Project_Number' the system should choos the same numbers in field  'Project_Ref'.

Would appreciate you prompt response.

Best

David

[Gysbert_Wassenaar]

You need to add a Select in Field action to the OnSelect trigger of the Project_Number field. The field to select in would be Project_Ref and the search string would be ='(' & concat(distinct Project_Number, '|' & ')'.

[#3]

if(Project_Ref = Project_Number,Project_Ref) as Project_Ref_match

[Anonymous]

See attached