View Single Post
  #1  
Old March 22nd, 2010, 09:51 PM posted to microsoft.public.access.tablesdbdesign
Serendipity
external usenet poster
 
Posts: 74
Default Table structure for separated families

Using Access 2003. I have a tblFamilies and a tblFamilyMembers. What do I do
when I have a "family" where the Dad lives at a different address and is
remarried and the Mom is remarried meaning that there is a stepdad and a
stepmom but they all need to get mail? I could just put them all in the
family members table with a fldrole where I put stepmom, stepdad, etc., but
that would necessitate putting the addresses in the tblfamilymembers which
would not be correct.

Thanks for your help.