We aren't there. We can't see your table structure.

When you say "they all need to get mail", how are you recording that fact
now? Are you using the "family members table" todetermine who gets mail?
If so, consider this alternative ...

trelWhoGetWhichMail
FamilyMemberID
MailID
...

With a "junction" table like this, you can list as many FamilyMembers as you
need to, plus which piece of Mail they are to receive. Notice that there is
NO use of FamilyID.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"Serendipity" wrote in message
...
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.