I'm having some difficulty in finding the unique records in a joint table. I have a joint table that has two primary keys from two related tables where key1 and key2 are the primary keys in the related tables.

Below is an example of a list of records in the joint table:

Key1 Key2

A1 123

A2 123

A3 123

A4 456

A5 456

For example I wanted to find the unique record keys of Key2, what is the find do I need to get

a return result of:

Key2

123

456

I'm not too concerned of which value key 1 is returned in the find.

Thanks.

Hi, FossilFM. This is not a find, but there is another method of doing this that may work for you:

Create a value list called valueListKey2 that gets its values from the field Key2. Now make a calc field equal to ValueListItems ( valueListKey2 ). The contents of this field should be all the unique keys found in Key2.

Jerry