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.

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.