I am a new user of Filmaker. I have encountered a problem.
Trying to develop a database that keeps track of the various projects.
It should contain:
• Project content.
• Which ones work with respective projects and what role the person has in the project.
• Overall employment list of all the projects.
Now the problem.
What I want to achieve is the following:
In every project I have two tabs, one for project leader and one for project assistants.
On each tab, I want a portal that shows who works as the tab name suggests. (In the assistants tab, I want to see who is working as assistants)
My approach is the following:
I have three tables,
Projects consist of:
ProjectParticipation consist of:
_fkProjectID (That's a drop down menu, with all projects, from the Projects table)
_fkContactID (That's a drop down menu, with all the staff, from the AdminContact table)
As (Which is a drop down menu with two choices, project leaders and project assistant)
AdminContacts consist of
I have tried to filter the portal in each tab (In the project table), after which choice you do in the table, ProjectParticipation. This has not worked.
How should I think and how do I go about it?
Grateful for answers and ideas