Expert: Srini Nagarajan - 7/23/2007

Question
Hi Srini !
I've written some asp pages which allow our test technicians to enter test data into an Access database. Three of the fields (primary keys) that they enter cannot be duplicated - if they are, I'd like to automatically change one of them in the background. Is this possible to do as part of the save page ?
Thank you very much !
Lorene

Answer
Yes,

You can do that without any problem, before saving first you have to select and find is there any records match with that 3 fields.  if so you can change one of the parameter and save back, infact you can run in a loop so that newly created 3 parameter also will be validated.

Hope you understand and let me know.

Happy programming!!

-Srini