Re: confusing relationships

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The answer to your question will depend what you need to store.

Using the example from:
http://allenbrowne.com/AppHuman.html
you could create a group of type "marriage", with 2 people in
tblGroupClient. If you want to track the full history of a person's
marrigage, these groups will need to be limited by date, i.e. the marriage
started on m/d/y and ended on m/d/y (blank if still current.) You will also
need BirthDate and DeathDate fields in tblClient, and based on all those
dates you could then retrieve the name of the person's current spouse(s).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"kingnothing via AccessMonster.com" <u18754@uwe> wrote in message
news:5d9f85ab18158@xxxxxx
Thanks Allen for your lightning fast reply...

Yeah, now its making more sense to me....i wuold rather have it the way
you
have said..but how does that solve the issue of a contact having multiple
spouses....and multiple children??

You have to excuse me if its a dumb question....i'm no software
designer...


Allen Browne wrote:
Not sure I would use separate tables for contact, spouse, and child.

It seems to me that these are people who could have policies in their own
right, so it makes more sense to me to put all the people in a single
table
with a ClientID primary key. Your Insurance table would then contain
foreign
keys for:
PolicyHolderID relates to Client.ClientID
Spouse relates to another record in Client table.
...

If one person has multiple policies, it might make sense to just have the
PolicyHolderID foreign key field in the Insurance table, and have all the
other family information in a different table. For a downloadable example
of
how that might work, see:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html


.

Relevant Pages

  • Re: confusing relationships
    ... have said..but how does that solve the issue of a contact having multiple ... If one person has multiple policies, it might make sense to just have the ... PolicyHolderID foreign key field in the Insurance table, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Traditional Marriage Wins in Maine
    ... people you can marry and which group of people you can't is the problem. ... The definition of marriage as understood by humans since time immemorial has been "a man and a woman" (or multiple "a man and a woman"s) It hasn't been a man and a man or a woman and a woman, especially since all the holy books for the past 5000 years have condemned the practice. ... Multiple wives implies multiple marriages of a man and a woman. ...
    (alt.smokers.cigars)
  • Re: OT: Politics Re: 2 Fantasy Rants for the Price of One
    ... >What are the marriage needs of an atheist couple? ... >"significant other" for insurance purposes. ... Inheritance rights. ... This is the really big one that's responsible for gay couples wanting ...
    (rec.arts.sf.written)
  • Re: Traditional Marriage Wins in Maine
    ... It'd be like if they said you can't marry outside your race or, more strictly, your majority ethnic background Or by religious affiliation -- Lutherans can only marry Lutherans, etc. ... The definition of marriage as understood by humans since time immemorial has been "a man and a woman" (or multiple "a man and a woman"s) It hasn't been a man and a man or a woman and a woman, especially since all the holy books for the past 5000 years have condemned the practice. ... Multiple wives implies multiple marriages of a man and a woman. ...
    (alt.smokers.cigars)
  • Re: Traditional Marriage Wins in Maine
    ... Multiple wives implies multiple marriages of a man and a woman. ... to be fruitful and multiply is not an absolute requirement. ... are you telling me that the children of Solomon and David are bastards because these kings had rather large numbers of wives? ... And multiple marriages are still a marriage between a man and a woman, ...
    (alt.smokers.cigars)