Repeating Field's question
I am trying to take data in a field (that has up to five strings of digits separated by a space) and move it to a repeating field. I would like to do this with a calculation. The main reason I am doing this is because I am trying to build a relationship between data in this database and a new one. Right now the relationship only allows it to match up to the first string of text in that field, but I might want one that is the third one in.
Any help would be appreciated. Maybe there is an approach that I haven't thought of yet.