I am still somewhat new to Filemaker and learning, but slowly.
I am trying to make a task manager database. I have three tables: Projects, Tasks, and Personnel. What I am trying to do is have all of the projects in a layout show in a list view and then in the header have a portal that shows all/only the tasks for a certain person in the Personnel table.
Currently, the portal is showing all of the tasks for the specified person (the portal filters for only one name) but only in the selected record and not in all records.
Is there a reason why it is doing this? Maybe my table relationships are off? I have the Projects table related to the Tasks table and the Tasks table to the Personnel table. The portal is from the Tasks table and shown on a layout using the Projects table. Or maybe I need to do something with variables?
Any help would be greatly appreciated.