Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 15th, 2004, 01:26 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

While I agree with pretty much everything said here, let's bring this back from a general discussion on candidate keys and the like to answering the original question from Cindy shall we?

Cindy,
You're dealing with patients right?
If you're in a hospital or something even remotely resembling a hospital, I'm guessing that there's already a way that the patients get identified. If there is, then use that.
That way, if you've got duplicates, at least they'd be consistent duplicates, and everyone would have a problem, not just you.

If you don't have a pre-established identifier, then I'd suggest using an Autonumber.
You'll probably find that you get duplicates in any event, but regular checking should help to overcome it.
If you find duplicates based on varying combinations of a few fields, such as:
Surname+FirstName+SSN
Surname+SSN
SSN
DOB+Surname+FirstName
DOB+Surname
DOB+FirstName
DOB
Surname+DOB+************
Surname+SSN +/- 10
FirstName+SSN +/- 10


then you should be ok



I am a loud man with a very large hat. This means I am in charge





Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help! Setting PK value at runtime! Darrell86 SQL Server 2005 6 November 20th, 2006 01:33 AM
Access ADOX - delete PK Derek_05 Access VBA 7 January 4th, 2006 03:32 AM
Access ADOX - delete PK Derek_05 Access 0 December 14th, 2005 10:56 AM
importing from flat file PK problem olambe Classic ASP Databases 3 October 18th, 2004 04:09 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.