Hi,

I have a table with 3 fields:

Field1: Key

Field2: Color

Field3: Maker

There are some records that share the same color. There are some records that share the same maker. The same could be true for any other values in field2.

I would like a portal to show only unique values for field2.

Any ideas?

Thanks in advance

VL_duplicates.zip

It's a little difficult to explain, but you can see in the attached file. You have to create a calculation field to produce the unique Serail ID of the line item when your criteria are met; Maker and Color in this case. It is an unstored field; so you cannot target it directly from Maker. You can however create another table occurrence of the line items table, and target the stored serial ID using this field.

So the portal for unique values goes thru the 1st child TO to the 2nd. It's a little difficult to see in the Relationship graph, as the lines cross over.

UniqueColors.fp7.zip

Thank you very much.

Excellent example. I understand the idea and will adapt it to my database.

Regards