February 14, 200719 yr Main question How can I put a index from a field in a variable (comma separated) for using for viewing those as possibilities in a custom massage box? A have now made a script with a loop starting by record 1 exit by last and set a variable by the following calculation : $$revision & "," & VN_xx_type::Revision. The problem is I can not avoid a duplication in the output string. For example : Record nr. 1 2 3 4 Field [File] A A B C Field [Revision] 01 02 01 01 The contents of the variable after performing the script will be : 01, 02, 01, 01 and I want have : 01, 02 Is there a simple possibility ( and of course there is !!) to realize this? :
February 14, 200719 yr Hi you can make a value list coming from values of the field: Revision So, a simple calc like this: Substitute ( ValueListItems ( Get (FileName) ; "yourValueListName" ); ¶ ; ", ") will make the job, without a looping script
Create an account or sign in to comment