🚀 go-pugleaf

Hi Kris,

i think this will not work because in the second step where the
master is the People_IN_GroupsTBL there is only groupid in
the actual record and so it will display only the details for this
record. Better you make a doubleclick on your detail dataset
component (People_IN_GroupsTBL) and then add a new field
for the groupname.
In the following dialog you can define it as a lookup field where
the value comes from the GroupsTBL and the reference is groupID.
So there should be one grid for selecting the actual person and in
the second grid you see all groupids and groupnames together, no
third grid needed.

hth,
Helmut


"kris leech" <krisleech@email.com> schrieb im Newsbeitrag
news:bc05su$h07$1@hercules.btinternet.com...
> 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.
>
>
>
>