You’re offline. This is a read only version of the page.
19
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?
Hi @schmucker,
You could use an embedded Canvas App to show a gallery and filter where Primary Target or Secondary target equals the current record.
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Hi @schmucker ,
Could you just add a choice column on the Offer table called Offer Type that would contain the values of Primary, Secondary and then you could relate to the Target table with this. This way on the Target table you could add the sub-grid of the Offers and show the Offer Type column to show both the Primary and Secondary offers.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
