[MS_AccessPros] Validation to SQL server field

 

I have an MS SQL server table with 2 fields: Job number, and reason
code. I built an Access form that saves data to the SQL table (through
a linked table). I'm pretty new to this, and am trying to figure out
how to prevent users from entering the same job# twice? I have a save
record button on the form. When I click it, If the job# already exists
in the table, I'd like to show a message saying "job# already exists".
What's the best approach to this?

Thanks,

Troy Sherven

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___