Problem with Inserting a record

[veerapureddy]

Hai everybody,

i like to insert some records into database from html form by entering data.my problem is how can i check , whether a record is available in database about a particular employee before inserting. if a employee record is available(for example based on employee num) , then if i try to insert again with that employee id, it should not enter into database(avoid duplicate records with same employee num)

can any one help me please, what should be the query.I am using java for inserting records and IDE is NETBEANS5.5

[MMcCarthy]

Hai everybody,

i like to insert some records into database from html form by entering data.my problem is how can i check , whether a record is available in database about a particular employee before inserting. if a employee record is available(for example based on employee num) , then if i try to insert again with that employee id, it should not enter into database(avoid duplicate records with same employee num)

can any one help me please, what should be the query.I am using java for inserting records and IDE is NETBEANS5.5

If you set the indexed property of the employee num field in the access database to Yes (No Duplicates) then Access will not allow the duplicate record to be added.

[veerapureddy]

If you set the indexed property of the employee num field in the access database to Yes (No Duplicates) then Access will not allow the duplicate record to be added.

Hai mmccarthy

Thanks for your answer, even i tried with access, i got the solution as u said. now its working perfectly. thanks for ur valuable time

[MMcCarthy]

Hai mmccarthy

Thanks for your answer, even i tried with access, i got the solution as u said. now its working perfectly. thanks for ur valuable time

You're welcome.