A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Avoiding Duplicates



 
 
Thread Tools Display Modes
  #1  
Old October 23rd, 2008, 04:20 AM posted to microsoft.public.access.tablesdbdesign
LindaH
external usenet poster
 
Posts: 9
Default Avoiding Duplicates

I am building a database with family information including social security
numbers for family members. I want to avoid including someone in more than
one family by not allowing a duplicate ssn. I'm not sure how to go about
doing this since there are several fields with ssn's for each family member.

Any suggestions?
--
Just Learning
  #2  
Old October 23rd, 2008, 04:40 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Avoiding Duplicates

On Wed, 22 Oct 2008 20:20:01 -0700, LindaH
wrote:

I am building a database with family information including social security
numbers for family members. I want to avoid including someone in more than
one family by not allowing a duplicate ssn. I'm not sure how to go about
doing this since there are several fields with ssn's for each family member.

Any suggestions?


Normalize your incorrect database structure.

The SSN (if it should be in your table AT ALL, it may violate some privacy
laws) should exist only once, in one People table. Each person, regardless of
how that person is related to other people, should have their own record.

Perhaps you could post a description of your table structure; it's quite
possible that someone could suggest a better table design.

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.