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?




      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?