1 Reply Latest reply on Dec 31, 2008 7:10 PM by Jens Teich

    Help a newbie?

    JeffreyG

      Title

      Help a newbie?

      Post

      I am new to Filemaker Pro and am trying to create a portal into a filtered detail table. The master table contains people's names and a primary key to uniquely identify each.  The detail table has monthly sales information and a foreign key to relate it to the master EE record.  I can create a portal into the entire detail table, but I'd like to have a drop-down with the years and then filter the results based on the year chosen and see monthly detail.

       

      I tried creating a filter in the detail table for a specific year and then using my layout with the portal, but i still see all the records.  Can someone please point me in the right direction?

       

      THanks