I have a Form layout showing records from an employee table. The form contains multiple tabs. A portal from a related table is defined on each tab. Ex: One portal displays all phones/faxes/cells assigned to the related employee. If New employee, a script writes 54 Tasks (each a record in a Tasks table, related by login) and displays in a portal on a Tasks tab. The Tasks portal contains Status field (selected from a value list). So far so good.

I have created 2 buttons above the portal: Show All and Show Open. I want the Show Open to omit any Completed tasks in the portal ONLY for the current record (employee). Instead it is omitting the records (employees) from the Employee Form if there are any completed tasks in the related table.

I am only 3 weeks into Filemaker, so I need some help, simply stated. Thank you in advance.

Why do you create 54 tasks for each new employee?

Anyway, you are looking to create what is called a filtered portal. Search for that and you'll find a lot of examples.