There is a couple of ways the first is to filter portal. Check the filter portal check box then specify. jobs::status ≠ "COMPLETE" . This will include all jobs::status record that does not equal "COMPLETE" or you can add this filter to your relationship.
OK .... hmm
I am on FM10 .... and I can't find any FILTER PORTAL ... :-(
Are you talking about functionality in FM 12 ?
FM11 introduced portal filtering.
You can still do it by modifying the relationship.
Say you now have this relationship for your portal:
LayoutTable::PrimaryKey = PortalTable::ForeignKey
but you want to omit all records from the portal where PortalTable::Status = "Completed".
Define a calculation field in LayoutTable, constCompleted and use the quoted text "Completed" as the sole term in this calculation. Select "Text" as the calculation field's return type.
Now modify your relationship to be:
LayoutTable::PrimaryKey = PortalTable::ForeignKey AND
LayoutTable::constCompleted ≠ Portaltable::Status
and your portal will now omit records where status = "completed".
Thanks a lot PhilModJunk ;-) You are the best :-)