Unique names in a field that does not allow duplicates.

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Unique names in a field that does not allow duplicates.

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Unique names in a field that does not allow duplicates.

Page: [1]

jvanscoyk

Posts: 18
From: Tucson, AZ USA
Status: offline

Unique names in a field that does not allow duplicates. - 9/10/2001 20:44:00

I have an Access db and I'm trying to add records to a table that has a field that does not allow duplicates in that field.
There are 2 ways I think I can accomplish this:

1) Write a form that will let me update the table and incorporate error handling that will intercept the error if the value that is trying to be put in is a duplicate and basically tell the user that the value already exists and to try another.
Is this possible and how?

2)Another way I thought to do it would be to use a 2-step form where the first form would use a SELECT statement to check if the value existed and if it did not to then move on to the 2nd form to added all the info to the remaining fields.

Any ideas of a better way to approach this?
Just need a nudge in the right direction.

Thanks,

Jim

Spooky

Posts: 26617
Joined: 11/11/1998
From: Middle Earth
Status: offline

RE: Unique names in a field that does not allow duplica... - 9/10/2001 20:28:00

Both have merit, heres a discussion that may be of value?

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=106

------------------
��k�
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
VP-ASP Shopping cart

(in reply to jvanscoyk)

Page: [1]

All Forums >> Web Development >> ASP and Database >> Unique names in a field that does not allow duplicates.

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts