I'm rewording a previous post. This may explain my problem better.

I have a 50,000+ record database. It has three types of items. I am
looking to run a find that would match Item 1 records with Item 2 &
Item 3 records of the same value in one of the fields. The result
would show the Item 1 records AND the corresponding Item 2 and/or Item
3 records.

The Dup ! function just isn't cutting it. Although it finds dups, the
starting point of the Item 1 selection as a main criteria isn't there.

Any suggestions would be appreciated.

Thanls...JohnB

In article <1179957890.487449.146490 (AT) u30g2000hsc (DOT) googlegroups.com>,
JohnB <bilecky (AT) excite (DOT) com> wrote:

SOunds like you could do it with a relationship.

Do a self-join on the field of interest. Put a portal in the layout of
the "Parent" table occurrence, with the portal showing related records
from the self-join.

Then all the records that have the same value of the field of interest
as does the "Parent" record will show up in the portal.

You can refine the relationship, to set a second criterion that the
primary ID fields of the related records not be equal to the primary ID
field of the parent record, so that the parent record does not show up
in the portal.

--
For email, change <fake> to <earthlink>
Bill Collins