Split string into Field values in a separate table.
Posted on 2011-03-11
I have two tables (TableA, TableB) which are joined in a one to many relationship. Table A contains a field (FieldA) with concatented strings eg.(10,15,20,25,30). I need to split the string in FieldA into separate values and place those values into the many side records of TableB. The example is:
FieldA.Value = 10,15,20,25,30
Split and Append or Edit Records to TableB:
FieldA.Value = 10
FieldA.Value = 15
FieldA.Value = 20
FieldA.Value = 25
FieldA.Value = 30
I believe I can use the Split Function to split the string into an array, but cannot figure out how to go from there. Thanks in advance.