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?