Help building an SQL statement

[Mithyrl]

I need help building an SQL statement that includes all the records of a recordset...except the current active record.

There is no primary key on this database and it is a DBase III database.

Any suggestions?

[JHausmann]

Is there a field or fields that make the current record unique?

If so

select * from table where field1 not='' (and field2 not='';etc)

[Mithyrl]

Ahhh theres the hitch I am checking what should be a unique field with the rest of the database to insure no dupes.

My code works when adding new records as the record being saved does not exist yet in the recordset.

However if editing an existing record this is where I have the problem...

If someone attempts to save the record without changing the Partnumber it will think there is a dupe as it exists in the recordset.

If I am able to construct a recordset excluding the current part I will be able to search for dupes.

Any ideas on a different approach? Or how I could write the SQL statement?

[JHausmann]

And your reason for not defining a primary key and letting the DBMS do all the dirty work for you is?

[Mithyrl]

Older Software that has to remain compatable is the reason.

I was stuck with this DBase III database and I have to live with it...if it were up to me I would use an Access database. But then again I dont get paid to make those decisions.

*sigh*

[JHausmann]

The older software could still use DBase, you could set up a process that copies the data to an Access database that it doesn't have to know about...