How do I filter portal records?

[Kevin Cheesman]

I need to have a portal showing all all people I need to call back. I only want my callback records to show in the portal.

In Access you just base the subform on a query. How do I do this in FileMaker?

TIA

[Osman]

Portals are shows related data. You can define relation ship in order to filter data. For example if you want to add date filter for your portal;

First define a date_field.

Then define a calculation field named DateMax which is equals to fallowing calculation:

"if( not isempty(date_field);date_field;"1.1.2999")

Define another calculation field named DateMin wich is equals to fallowing calculation:

"if( not isempty(date_field);date_field;"1.1.999")

Add fallowing inequalities in your relationship:

date_field in related table >= DateMin

date_field in related table <= DateMax

It is okay. If user enters the date into date_field, portal only shows sellected date. But if the field date_field is empty portal shows related records for all dates.

[Kevin Cheesman]

Thanks