The intention is to provide the user of the database with the ability to click on a button in this show bar and have FileMaker show only those records belonging to the same department, project or employee. This solution capitalizes on the Go To Related record script step quite heavily. The Showbar added into your list layout would allow for the feature I call 'drill-down' list filtering. What this technique shows you is how to create what I call the record 'Show bar' in a list view. Task, Department, Project, and Employee fields are the only ones you'll need starting out. This is all quite simple when it comes to tracking this information in a database. Even better is to know what's going on with which project in which departments and who is doing what. It is important for both managers and employees to know what they have to do.

Each task, as we will call them, is typically assigned to an employee.

For most companies this is broken down by department and then by project. One of the more difficult tasks in a growing company is keeping track of who is doing what, what needs to be done, what is being done on time and why isn't even being done in the first place. I developed it recently to manage my own company. I loved creating it, and likely you'll enjoy investigating it.

Filtering a list view filemaker pro 16