Basic query question - crosstab?

How do I to create a query (or Datasheet) that has that little plus sign so
you can click it to expands the field to show the sub categories of each
entry? Is this called a crosstab query?

I've seen some mdb's with this kind of thing but I forget what it's
called...

Thanks in advance.

re: Basic query question - crosstab?

deko wrote:[color=blue]
> How do I to create a query (or Datasheet) that has that little plus sign so
> you can click it to expands the field to show the sub categories of each
> entry? Is this called a crosstab query?
>
> I've seen some mdb's with this kind of thing but I forget what it's
> called...[/color]

Access 2000 and later versions.

That is a subdatasheet. See Access Help for further info.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

re: Basic query question - crosstab?

> Access 2000 and later versions.[color=blue]
>
> That is a subdatasheet. See Access Help for further info.[/color]

That's the ticket... from what I've read so far, I need to set my subform
(datasheet) SourceObject to a query that has a one-to-many relationship with
the data I want to view in the subdatasheet. The interesting part is going
to be setting up the relationships between the queries.

Thanks for the help.