Hi
This is a very simplified version of what I am trying to do.
I have 2 tables. The first is standard F&O VendTrans and the second is a custom table xxxVendCert. The second table contains the VendAccount , CertId , DateFrom and DateTo. The DateFrom and DateTo does not allow any overlapping of dates for the specific vendor.
How can I create a DataEntity where I can show all the VendTrans record with the CertId. I want to create a outer join between VendTrans and xxxVendCert where VendTrans.TransDate between xxxVendCert.DateFrom and xxxVendCert.DateTo. Or alternatively add a range where the range includes the Transdate of the VendTrans records.
Kind regards.