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?

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, 200520 yr by Guest
Added a template

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