Master > Detail/Master > Detail with ADO

Article View: borland.public.delphi.database

Article #85

Back to borland.public.delphi.database Previous Next

#85

From: kris leech
Date: Sun, 08 Jun 2003 20:21

19 lines
1894 bytes

Hi all,

I have three tables PersonTBL (PersonID), GroupsTBL(GroupID) and
People_IN_GroupsTBL(PersonID, GroupID)
To relate a Person to a Group I add a record in the People_IN_Groups table
with the PersonID and the GroupID of the Group they are related to.

I have a form showing the People Table, but I want to display all the Groups
that Person is in also. To do this I have put PersonTBL as the Master to
People_IN_Groups, and People_IN_Groups the Master of Groups, so:

People_IN_Groups shows only records for the PersonID of the the current
record of PersonTBL,
GroupsTBL showing only the Groups of the current record of People_IN_Groups.

Now this does not quite work as I need to show all the Groups in
People_IN_Groups, not just the current record. How do I do this please?

Many thanks. Kris.

Technical Details

Message-ID: <bc05su$h07$1@hercules.btinternet.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!btnet-peer0!btnet-feed5!btnet!news.btopenworld.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,2e9a4ef88d2d6384,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-06-08 13:22:14 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!btnet-peer0!btnet-feed5!btnet!news.btopenworld.com!not-for-mail
From: "kris leech" <krisleech@email.com>
Newsgroups: borland.public.delphi.database
Subject: Master >  Detail/Master >  Detail  with ADO
Date: Sun, 8 Jun 2003 20:21:50 +0000 (UTC)
Organization: BT Openworld
Lines: 23
Message-ID: <bc05su$h07$1@hercules.btinternet.com>
NNTP-Posting-Host: host213-122-107-67.in-addr.btopenworld.com
X-Trace: hercules.btinternet.com 1055103710 17415 213.122.107.67 (8 Jun 2003 20:21:50 GMT)
X-Complaints-To: news-complaints@lists.btinternet.com
NNTP-Posting-Date: Sun, 8 Jun 2003 20:21:50 +0000 (UTC)
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MSMail-Priority: Normal
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000