July 20, 200619 yr 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
July 20, 200619 yr 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.
Create an account or sign in to comment