8 Replies Latest reply on Apr 4, 2017 8:41 AM by philmodjunk

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

    aj15

      Hi!

       

      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?