Is there a function for determining if a value is unique?

[mahonia]

I want to incorporate the question of whether a seperate field contains a unique value into a calculation.

i.e, Field 2 = if ( field 1 ValueIsUnique

= true, result A, result B )

Anyway to do this?

Edited October 1, 2005 by Guest

[LaRetta]

Hi Mahonia,

To isolate a unique field value across a range of records, you need to create another table occurrence (maybe called UniqueField1) joining field 1 to itself on =. Then field 2* (calculation, result of text) would be:

If( Count(UniqueField1::Field1) > 1 ; Result B ; Result A )

* Field2 will NOT update as a standard field. For it to update reliably, it must be a calculation which will automatically be unstored. Auto-enter (Replace) on a standard field will not work here because it references related data.

LaRetta