Look for the next occurrence in a field and fill another field as a Predecessor

Hi all.... I am very new in Quickbase and I would like to find a predecessor info in a string field and fill another field with it. I am doing it just to find the repeat occurrences based in anoth...