"Barry Bulsara" <bbulsara23_at_hotmail.com> wrote in message
news:1102453241.26929.0_at_damia.uk.clara.net...
> Hi ana, a family is anyone related anyway to anyone else in this model.
> Basically for Brians family, there exists some sort of connectivity
between
> Francis, Bruce, Claudine, Peter, Brian, Joan, and Bob but no connectivity
to
> Francois etc.
>
> Brian and Mary are related as the names Brian and Mary exist as one of the
> rows in the table "family". Mary and Bob are related because the names
Mary
> and Bob exist as one of the rows in the table. Therefore Brian, Mary, and
> Bob (and all other others) are related and I want to be able to pull them
> out from the remainder of the data in the table.
>
> FWI ultimately I need to retrieve each of the families GROUP BY so I can
put
> them into a more usable structure. Sadly however the data isn't very clean
> either so I will be massaging considerably before I do this. At the moment
I
> just want proof that I can go SELECT personname FROM something WHERE
family
> is someone in the family. I'll work on the other more laborious bits
later.
> Hope this explains it a bit further.
> Barry
>
>
>
> "ana" <anacedent_at_hotmail.com> wrote in message
> news:31mf2bF3dq0v6U1_at_individual.net...
> > "Barry Bulsara" <bbulsara23_at_hotmail.com> wrote in message
> > news:1102447259.4791.0_at_lotis.uk.clara.net...
> >>
> >> Daniel, I can't change the structure. I am not designing this, it is
> >> what
> > I
> >> have to work with, and I have to get the information into a proper
> >> structure.
> >> The reason I have chosen familymember1 and 2 and the contrived data is
to
> >> make the explanation simple and hopefully get on the road to a simple
> > query.
> >> Regards
> >> Barry
> >
> > It is NOT clear to this reader the relationship between familymember1 &
> > familymember2;
> > other than somehow they are related to each other.
> >
> > What gets reported for cases where more than TWO generations are in the
> > table?
> >
> > Why only TWO members in the table when every child has a mother and a
> > father?
> > Dick marries Jane and have two kids John & Sue.
> > John grows up, marries Sally and has Jeremy & Nadine.
> > Sue grows up married Ted & has Samantha & Tyler.
> > What's in your DB for this case & who gets reported as a "family"?
> >
> >
>
I'm willing to bet dollars to donuts that given the existing table structure
(or lack thereof)
you won't meet your design goals by applying any single SQL statement to the
two column table.
This table is, IMO, a brian dead, borderline useless collection of pairs of
data.
ACCESS can be down right dangerous when placed in the hands of an untrained
person.
Received on Tue Dec 07 2004 - 15:22:31 CST
