AnsweredAssumed Answered

problem with empty lookup field

Question asked by liyangao on Jun 5, 2012
Latest reply on Jun 6, 2012 by comment

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!

Outcomes