Hello!

I am working in *.db where I have the following elements:

Ticket Number
Manifest Number
Trucker

In my business, the ticket number element must be a unique. (key)

I had a situation arise where I had two records with the same ticket and manifest number but different trucker values.

After running a retreive on all records, under Result Commands: Remove Duplicates From Results.  Sesame did not find any duplicate records.

As specified on page 172 Users Guide. Sesame did not find any case-blind matches for all fields in the database.

As stated on Page 173 Users Guide: Q&A had a different delete duplicate procedure where you must specify which fields should be matched to determine a "duplicate'.

What I needed Sesame to do is find a duplicate for a specific element.- ticket number.  In this case, it would have retreived two records with same ticket number.

Has anyone ran into this situation or offer any tips? ???

Is there a "Restriction" that needs to be in place for this element -Ticket number for a unique field?

or could there be a spec window in the spec manager like (Sort, Import, Export, Copy) that can be for selecting elements in which to check for duplicates on specific elements? Not the entire form.

Regards,

David Costanzo