Check for existing DB entry

I am using FP 2003 with an Access DB, and I am looking for some assistance with checking for an exisiting value in the DB at the time of submitting the data to be certain a duplicate is not getting entered.

Any assistance would be greatly appreciated.

Thanks
David

There are a couple approaches you can take. I usually just query the db for the record in question, look at the resulting recordset and see if it's empty or not, if empty proceed with the insert else provide a message about the record already existing.

Within the DB you can put a unique index on the record, and your code can just do the insert and check for an error or not returned by the db.

HI


Deleting duplicate qurerry in your db is okay...but i have no idea how to use FP and instuct you that you have entered the same

To find a solution for this quite difficult

Thanks & Regards
web development company
Prodigy Apex technologies