[AccessD] Primary Key Violation

I am actually using an AutoNumber for an ID that links them to the other 
pertinent tables, but when they go to enter or edit their data, they don't 
know this number so if they've already put in their data and they attempt to 
do it again instead of editing what's already there, I can't ask them for 
anything but their name to check if they've already entered data.  I'm open 
to any better suggestions.

Thanks for your help,
Gina


From: "Charlotte Foust" <cfoust at infostatsystems.com>
Reply-To: Access Developers discussion and problem 
solving<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem 
solving"<accessd at databaseadvisors.com>
Subject: RE: [AccessD] OT: Primary Key Violation
Date: Mon, 17 Nov 2003 11:34:08 -0800

Gina,

There is no such thing as a one-time use application, trust me.  If it
works, they'll want to keep using it.  Do yourself a favor and use an
artificial key rather than the staff names.  You can still create a
unique key with the name and something like their work phone number,
which you should surely be able to collect.

Charlotte Foust

-----Original Message-----
From: Gina Hoopes [mailto:hoopesg at hotmail.com]
Sent: Monday, November 17, 2003 11:08 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] OT: Primary Key Violation


No offense taken, Martin, I've seen the carnage.  Fortunately this is a
one-time use db that I have to put together quickly and we don't have
any
staff members with the same name.  This time ...

Gina

_________________________________________________________________
MSN Shopping upgraded for the holidays!  Snappier product search... 
http://shopping.msn.com