Hi
I have a Offers table where there is a m:1 relation to a Target table called Primary target.
In the same Offer table I also have another relation called Alternative target also m:1 to the same Target table.
This means that a offer can relate to two different targets one primary target and one alternative target.
My goal is that on my main form for Targets I have to show a subgrid that shows both the primary and alternative offers for the given Target, but all in one and the same grid view on the form.
It's not a problem to show them in two different subgrids but I'd really like to merge it into one.
Is it possible and how?