Help a newbie?
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?