3 Replies Latest reply on May 29, 2014 6:12 AM by philmodjunk

    Opposite of List function

    aaparvez

      Title

      Opposite of List function

      Post

           A field was created by List function.

           But now i want to create multiple records from the list values. How to do that , kindly help me. Thanks

        • 1. Re: Opposite of List function
          philmodjunk

               What do you mean by:

               

                    A field was created by List function.

               Is that a calculation field?

               What do you need to see in your "multiple records", one record for each value this field? With a value from the field entered into a field in that new record?

               Best guess:

               Set variable [$List ; value: YourTable::YourListField]
               Loop
                 Set Variable [$K ; value: $K + 1 ]
                 Exit Loop If [ $K > ValueCount ( $List ) ]
                 New Record/Request
                 Set Field [YourTable::ValueField ; GetValue ( $List ; $K ) ]
               End Loop

          • 2. Re: Opposite of List function
            aaparvez
            thanks for your helpful reply. iwant to create single records for each of the value in another field. actually what I needed is I wanted to find and match records in TableB by each of the values in list field at tableB, then showing the matched records from TableB. I planned to create records from the values in list into the TableAnother. then making relation with tableB and TableAnother and showing GTRR. IF you have any alternative, please let me know. thanks.
            • 3. Re: Opposite of List function
              philmodjunk

                   I am sorry but I can't follow your description of what you want to do.