Basic query question - crosstab?

[deko]

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.

[MGFoster]

deko wrote:

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...

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)

[deko]

> Access 2000 and later versions.

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

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.