10 Replies Latest reply on Jul 1, 2014 2:12 PM by LaRetta

    I need a help to make script to separate the multinumber in a field.

    chs0615

      I have two table, Member and Number.

       

      Member contains MemberID, MultiNumber. (Ex. 100001 / 700001,70043,30003,32123 [MultiNumber field contains 1 thru about 10 number, it might have space after comma]
      Number contain ID and Number.

      I make relationship one to many ( Member --< Number )

      Now I want to separate Multinumber and copy into potal container Number. How can I make a script to seperate like down below?

       

      MemberID: 100001 Potal 100001 700001

      100001 70043

      100001 30003.....

      Thank you.

      Khris