Portals within portals not possible??

[RichardBurrow]

Hi all,

I wonder if anyone out there can help. I am working on a job management system and I have hit a bit of a brick wall in filemaker

namely the lack of ability to display portals within portals.

In my job management system I have a jobs table, a job stages table and a staff table.

For the particular layout where I am having the problem i have created a parent - child - grand child relationship with jobs to job stages to staff.

The jobs layout shows job stages associated with the job (as you can see)

The problem that I have come up against is that I want to add staff members to the job stages and because there can potentially be more than one member of staff associated with a job stage I need to use a portal to display these related records, this becomes a problem because of the filemaker limitation that you can display a portal within a portal row.

Any suggestions on how this could be achieved differently using other methods would be hugely appreciated.

[bcooney]

You are correct, you cannot display portals within portals.

But in your case, you do have a join table btw the JobStage and Staff tables, correct? That's the table to populate when you assign a staff member to the job stage.

You can have the Add Staff button, popup a Staff List from which the user will select a staffID. Then, use the List ( ) function to create a calc in JobStage of the related Staff Full Names in the join table.