Filtering of one portal depending on the line items added in the other portal

Discussion created by tony-v on Aug 16, 2017
Latest reply on Sep 8, 2017 by philmodjunk

Dear Sirs,


I am quite new to File Maker, however trying to develop some solution.


Here is the situation I am trying to find a way out of.

First thing, I am trying to alter the Invoice starter solution to get the required result.


I have a number of tables. They are:

- Projects

- Companies

- Invoices, and

- Invoice Lineitems


There is the Invoice Details layout based on the Invoices table. I have located the main portal at this layout, which is related to the Lineitems table. I use a popover button and another portal to select and add lineitems to the main portal. This selection portal is linked to the Projects table via a relationship as shown at the screen shot below.

Screen Shot 2017-08-16 at 23.02.40.png

The question is how do I set the portal filtering so that after a project is selected in the popover portal, added and appears in the main portal it disappears and is no longer shown in the popover portal?

Screen Shot 2017-08-16 at 23.06.42.png


Many thanks in advance.