Error Check

  • Thread starter Thread starter James
  • Start date Start date
J

James

Probably a simple question to answer.... I'm adding records to a table
"UserIDandPassword" the primary key is "UserID" . When I click the Add
button, it adds a record. How do I get it to error check that the
UserID that wants to be added doesn't already exist? Thanks.
 
Make the UserID the primary key of the table, and you will not be able to put
in a duplicate UserId.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Syntax Error in UPDATE statement?? 5
Simple Question 2
Data Entry Form and Auto Number ID 2
Same form for new/edit record problem 4
Autonumber.... 9
SQL select statement issues 2
Command Button 1
relationships and reference tables 2

Back
Top