[MS_AccessPros] Re: Duplicates in a field

 

Hi Katrina,

Yes, in the design view of your table, set the index property for the citation number to "Yes, No Duplicates."

Doyce

--- In MS_Access_Professionals@yahoogroups.com, ka0t1c_ang3l <no_reply@...> wrote:
>
> Hello everyone!
>
> I'm creating a new database for our Public Safety Department. In my database I have a Citation Number that is issued. Is there a way to code this field to prompt me that the number entered has already been used to avoid duplicate numbers being issued?
>
> Any help is appreciated!
>
> Thanks!
>
> Katrina
>

__._,_.___

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

Messages in this topic (2)

Recent Activity:

• New Members 6

Visit Your Group

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

.

__,_._,___