Code

Var vCertLoop as Int
Var vCertCnt as Int
Var vCELoop as Int
Var vCECnt as Int
Var vCertType as String
Var vCEsTaken as Int

	vCertLoop = 1
	vCertCnt = @FormResultSetTotal("Certifications")
	vCECnt = @FormResultSetTotal("CEs")

	While vCertLoop <= vCertCnt
	{
		vCertType = @FormFieldValue("Certifications", "Cert Type", vCertLoop)
		vCELoop = 1
		vCEsTaken = 0
		While vCELoop <= vCECnt
		{
			If vCertType = @FormFieldValue("CEs", "Cert Applied", vCELoop) Then
			{
				vCEsTaken = vCEsTaken + @ToNumber(@FormFieldValue("CEs", "Units", vCELoop))
			}
			vCELoop = vCELoop + 1
		}
		FormFieldValue("Certifications", "CEs Taken", vCertLoop, vCEsTaken)
		FormCommit("Certifications")
		vCertLoop = vCertLoop + 1
	}
	FormCommit("")