replace ALL IN fktable ; fkdata1 with LOOKUP(pktable.pkdata1,fkid,pktable.id,'pkid'); , fkdata2 with pktable.pkdata2