View Single Post
  #3  
Old March 22nd, 2010, 10:42 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Table structure for separated families

Here's my thought, I would like and welcome others to give theirs.

You have to start by defining your mission(s)

Does it include tracking all of these people and the relationships to them?

If "family" is an entity that you are tracking, then you are going to have
to define what "family" means for the purposes of your database.

Is your mission to get properly addressed mail to all of these locations?
If so, you probably need a "mailing" table independent from all of the other
tables. Key fields would be:

Address
City
State
Zip
WhatShouldBeInTheFirstLineOfTheAddressLabel (of course, shorten that
field name)

This could be linked to people and families (per your definition) as needed.



Well, there's one idea!