AnsweredAssumed Answered

How can I show records that are not in the join table?

Question asked by aj15 on Apr 3, 2017
Latest reply on Apr 4, 2017 by philmodjunk



I've been trying all day to get this working with no joy. I'm sure I'm missing something obvious...


I have three tables:

  • Table A (Designs)
  • Table B (Amends)
  • Join Table


Table A contains designs, Table B contains customer amends. The same amend can affect many different designs so I am using a join table.


On a layout based on Table B (Amends) I have a portal showing the related Designs from Table A - Easy!


What I want on the same layout is another portal showing ONLY the designs in Table A that DO NOT relate to the particular amendment that is being viewed. Surely this is possible?