I have a database that manages all my clients plus all projects plus other items.

On the home page I have a portal that is currently showing me all active projects.

There is a relationship in the home db in s field called gStatus to the project field called status.

I'd like to create a second portal on the home layout that can show me all pending projects.

I've tried creating another field but how do i tell the new portal to use the new field for its view.

Any advice on how I should go about this would be great.

Create another table occurance of the projects table and have another relationship from another global field with the value "Pending" to the project status field. Have the portal be based on that new relationship and table occurance.

Thank You

That worked wonders :)