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