RFQ -> PR relation in D365fo X++
RFQ -> PR relation in D365fo X++ Code: public str getPurchReqNo() { PurchReqTable PurchReqTable; PurchReqLine PurchReqLine; PurchRFQCaseTable PurchRFQCaseTable; PurchRFQCaseLine PurchRFQCaseLine; select PurchReqTable join PurchReqLine where PurchReqLine.PurchReqTable == PurchReqTable.RecId join PurchRFQCaseLine where PurchReqLine.LineRefId == PurchRFQCaseLine.ReqLineRefId join PurchRFQCaseTable where PurchRFQCaseLine.RFQCaseId == PurchRFQCaseTable.RFQCaseId && PurchRFQCaseTable.RFQCaseId == this.RFQCaseId; return PurchReqTable.PurchReqId; }