Going to related record in same table
I have a contact list of 4000+ names. Each record represents a camper who attended a camp, or their parent (s). The camper and the parents have a uinque ID. The camper may go on to become a counselor, then may become a parent of a camper themselves. I need to go from the camper record to the parent record by using a script. All records need to be in the same table. Can this be done?