In Filemaker we don’t have option for display unique records in portal. But we can do this by using a simple auto enter calculation field.
Suppose we have Sales table with duplicate ContactID and want to display records in a sales portal with unique ContactID, we only need to define a simple number auto enter calculation field with the option “Do not allow to replace existing contents” checked.
|
The auto enter calculation needs to be: DuplicateContactID (Sales table) = Count ( SALES_SELF__ContactID::ContactID ) This is a self-relationship of Sales table based on ContactID (Desired duplicate field).
Then you can use this “DuplicateContactID” field in your portal relationship (SALES_SELF__Constant_DuplicateContactID) as:
Constant (SOURCE Table) > DuplicateContactID (DESTINATION Table) As per the above mentioned example both fields used in relationship are from Sales table.
Here, the constant is calculation field in Source table having value 1. So, with the help of this relationship, you can get all the Sales records with their unique ContactID.
|