[AccessD] Unique Record Pull

Hi Gowey

If you need to edit/delete those pulled records, you'll probably have
to fill a table with the unique records and then use a form bound to
these and with a linked subform bound to the multiple records.

Don't forget to disable deletion of records from the subform when
recordcount reaches one.

/gustav


> I have run into a little snag on the project I am working on.  I have a
> linked table from Oracle that contains records that have not passed a
> verify process because they have something wrong with them in one of the
> fields, in other words it does not meet the criteria.

> Each record has a unique ID number and the same person can be repeated
> many times.  For example one person can have multiple records in the
> table with a different ID number but the same SSN number, last Name and
> First Name.  

> Here is where I have run into a snag, I want to be able to only pull
> from the table one of these records for each SSN and I need it to show
> the ID number of this record and display this set of records in a form
> for the user to be able to scroll through.