I've used Set Relation to relate a parent to child and I'm attempting to update all child records with a value from the parent record. I can get it to update the first of the child records for each parent but if there is more than one child record those don't get updated.
Here's the code
I've tried lots of variations on the REPLACE line using FOR, WHILE etc to no avail
Here's the code
Code:
GO TOP
m.tmkey=contact1.recordid
DO WHILE NOT EOF()
REPLACE contact2.recordid WITH m.tmkey
SKIP + 1
m.tmkey=contact1.recordid
ENDDO
I've tried lots of variations on the REPLACE line using FOR, WHILE etc to no avail