Highlight Portal Specific Portal Records

[rpan]

I have a situation where I would like to highlight specfic records within a portal. If a series of records within a portal has the same data within a specific field. I would like it to stand out some how. Does anyone have any ideas?

An example:

Let's say I have a portal with five records in it with one field per record.

In the field is a food item. Let's say

Record 1 has "eggs"

Record 2 has "fish"

Record 3 has "cake"

Record 4 has "eggs"

Record 5 has "Turnips"

I would like to make the portal highlight eggs because that piece of data has been repeated within the portal. When I mean highlight, I am just looking for any way to highlight it. (i.e. change the color of the text, put an asterisk near it, whatever) any suggestions?

[Søren Dyhr]

It's needless to say that it becomes much more easy when turning to 7.0.

I would probably in you case make a compundkey of the foreign key and the value and make a selfjoin looking at the records serialnumber which is compared with the related serialnumber.

If they differ is it a dupe.

This can be a mergefield of "gggg"'s in the webdings fond that the Case( statement makes show or not.

Meanwhile have I made you a template to show what I mean!

--sd

Highlight.zip

Edited August 15, 2005 by Guest
Added a template

[rpan]

I am using filemaker 7. Thanks for your response in FM 6. Any better ways to do it in Filemaker 7?