Re: Linking 4 child tables to 1 Parent table

First, if 3 tables are related one-to-one to the main (parent) table, why
are they separate tables? I'm not saying that they shouldn't be, I'm asking
what they contain that made you decide they need to be separate?

Next, the way to relate any child table to a parent table is to include a
field in the child table that will hold it's "parent's" ID/key -- this is
how it knows which parent it belongs to.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"larpup" <larpup@xxxxxxxxx> wrote in message
news:1144956607.391516.80510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a Parent table with a key field. I have 4 child tables. One
table is a many-to-one relation and the other three are one-to-one.
The three that are one-to-one may or may not have data entered into
them.

My question is; What is the best way to link these 4 tables to the
parent table?

The 4 child tables are all (really) related to the key field of the
parent table, but this has brought problems in underlying queries in
some forms. Appreciate any advice.

Lar



.

Relevant Pages

  • Re: Safety and the Laws
    ... "I find it hard to believe that any parent would be ... "To have your child standing, unrestrained, in the passenger foot ... heading in the seventies when I sat completely unrestrained in a car. ... I'm not saying it's big or clever, ...
    (uk.rec.driving)
  • Re: Safety and the Laws
    ... "I find it hard to believe that any parent would be ... "To have your child standing, unrestrained, in the passenger foot ... I'm not saying it's big or clever, ... Maxi coming back from Lincs sharing the boot with a twin-tub washing ...
    (uk.rec.driving)
  • Re: Connecting to the Same Table Twice
    ... RelationshipID (primary key) ... RelationshipName (parent, guardian, authorized pick-up, emergency contact, ... you might put spouse names into a separate table linked to this table). ... for each link between a child record and a caregiver record, ...
    (microsoft.public.access.gettingstarted)
  • Re: Child Molested At Homeless Shelter
    ... are there no foster homes for these kids? ... but we're supposed to think it's okay to make a child do so? ... that's exactly what I'm saying. ... > parent has a responsibility to provide adequate food and shelter. ...
    (alt.true-crime)
  • Re: Connecting to the Same Table Twice
    ... > RelationshipID (primary key) ... > RelationshipName (parent, guardian, authorized pick-up, emergency contact, ... > you might put spouse names into a separate table linked to this table). ... > for each link between a child record and a caregiver record, ...
    (microsoft.public.access.gettingstarted)
Loading