Michel,
I haven’t don’t this specific thing, but this might help you:
- I’m surprised the Requisition comments do not feed into the PO Suggestion.
- When the Suggestion is created it records the ReqNum & Line in the suggestion record.
In a BPM if the ReqNum is not blank then I would use the Setter widget to set the SugPODtl.CommentText to the following Expression(untested):
Db.ReqDetail.FirstOrDefault(r => r.Company == ttSugPODtlRow.Company && r.ReqNum == ttSugPODtlRow.ReqNum && r.ReqLine == ttSugPODtlRow.ReqLine)?.CommentText ?? ""
I see you are in Michigan, perhaps we can meet at the next MI-IN EUG meeting?