I have two related tables that I want to show on the same form, a PROJECTS table (in a portal) and PROJECT ITEMS table (in a portal).
The PROJECT ITEMS table is relatied to the PROJECTS Table in a 1 to many relationship.
On a form, I would like to show all the projects in one portal (from the PROJECTS Table), and then when I select a project in the PROJECTS portal, show all the associated records in the in the PROJECT ITEMS records portal.
How do I do this? I intend to use this form in Filemaker Go.
I'm using Filemaker 11 Pro