Filtering value list with 2 criteria for the same field
I have a table containing personal data: Name and Address
In a layout, I have two pop up field to choose 2 persons from the above table.
I would like to have another popup field to show the addresses of the 2 persons selected plus another constant address which must show up no matter which person is selected. So there should be 3 addresses showing. Person A & B and the constant address.
How to achieve this?
Please provide some more details as I am new to FMP but i used to be MS Access usser