AnsweredAssumed Answered

Portal problems and/ or errors of thought?

Question asked by elephant on Apr 18, 2013
Latest reply on Apr 19, 2013 by mikebeargie

Hello!
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
ProjectParticipation
AdminContacts

Projects consist of:
__pkProjectID

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
__pkContactID

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


Outcomes