Indicating similarities between records in a portal

[rpan]

I need to figure out a way to indicate that two records are similar within a portal. Within the portal records I have a specific field that where I want the value to be unique within the portal. If any of the values within the fields of the record within portal are the same I'd like to indicate that somehow or make it stand out. Does anyone have any suggestions?

[bruceR]

Conditional formatting and use of the self, list, and filtervalues functions can help you.

Let ( portalValues = list( TO_name::fieldname);

valueCount ( FilterValues( portalValues; self)) > 1

)

[Søren Dyhr]

If just conditional formatting were availiable in fm6 would it make sense Bruce.

You must create a composite key in the portals file and then selfjoin it with this key, and count if the number of records with identical composite keys is more than one. This is then used in a calc'field producing a bar of say webdings "g" if condition is met. I usually did this with a mergefield underneath transparent fields.

--sd