Showing if a portal row is connected through an alternative relationship

[Hugh Macdonald]

Hi,

I'm trying to figure out how to get the information I want in a portal field...

I have three tables in my database, A, B and A_join_B

My relationships are (B is in the relationships graph as both "B" and "B_alt"):

• A.id = A_join_B.A_id
  
• B.id = A_join_B.B.id
  
• A.id >= B_alt.min_A_id
  

Anyway, what I'm after is the following:

My layout is of the A table.

I have a portal pointing at B_alt, but, as a part of this, I want to have something in each portal row saying whether B is linked to A through A_join_B.

Any idea how I could do this? Can I create a calculation field in B that will come up in the B_alt portal rows?

I hope this makes sense - please let me know if you would like me to clarify anything.

Thanks

[comment]

I believe you could use conditional formatting - something like =

not IsEmpty ( FilterValues ( Self ; List ( B:_ID ) ) )

where Self is B_alt:_ID placed in the portal.

---

P.S. Please don't use abstract names - it's really difficult for us humans to follow.