| Les Matthews 2005-03-08, 6:47 pm |
| It sounds like you want a nested repeat region.
http://www.tom-muck.com/extensions/...ednestedregion/
"Aleks" <arkark2004@hotmail.com> wrote in message
news:d0l3ki$f7n$1@forums.macromedia.com...
>I am using ASP/VB and MS SQL 2000
>
> I have a recordset that I filter out, it has an ID, this table is called
> 'persons'
> Then I have another table called 'children', this table has its own id's
> but it also has the ID from 'persons'
>
> So that one record from 'persons' could have one, none or multiple records
> from 'children' which are linked by the ID of the person.
>
> This is table persons:
>
> ID - Autonumber
> Name - nvarchar (Here goes the name of the person)
>
> This is the children table:
>
> ChildId - Autonumber
> PersonId - ID from the persons table
> Name - Name of the child
>
> How can I return a query that will display one row ONLY for the 'person'
> and then all the rows for the child that are linked to the 'person', could
> be none or multiple rows.
>
> I could not do this with a left join because if I did it would display the
> name of the person several times.
>
> I hope I explained myself.
>
> A tutorial would be great.
>
> Thanks,
>
> Aleks
>
|