Backfill name data from one column to another

Thu May 09 2024 13:24:16 GMT+0000 (Coordinated Universal Time)

Saved by @nishpod

	for each rec in Large_Issue_Section_20_Tracker
	{		
			for each line in rec.Action_Log
			{
				var = line.Staff_Member_Responsible2.Email;
				var2 = Add_POD_Person[Alias_Email == var].ID;
				line.Staff_Member_Responsible = var2;

Action log is a subform in Large Issue Staff_member_responsible is a lookup field dont use name since its a composite field, use something like email to match each record first - fetch email from ID in staff member - use it to find matching record in pod person and grab ID - feed the ID into the new lookup field