I have a 1 to many relationship between mother and children. For each children record, it has a field called kidschoolreportID. I defined a lookup field in mother table to copy the non-empty momschoolreportID from the children into their mother's record. The problem is that I got a lot of mother record with empty momschoolreportID while some of her kids have nonempty kidschoolreportID. Why doesnot it work? Is there any workaround to copy the nonempty kidschoolreportID to mom's record?
Thanks for your help!