Combine data for report - Problems with column / rows

[yovation]

Hello,

I have a 3 table product database.

1) Products (Parent)
2) Attributes (Child)
3) Options (Child of Child (Attributes))

Here is the problem I am having.

I need a report that looks like this: - The first field of every
table needs to be displayed in same column.

Product 1
1st Attribute of Product 1
1st Option of 1st Attribute
2nd Option of 1st Attribute
3rd Option of 1st Attribute
2nd Attribute of Product 1
1st Option of 2nd Attribute
2nd Option of 2nd Attribute

Product 2
etc......

Thank you.
yovation

[Tom van Stiphout]

Re: Combine data for report - Problems with column / rows

On Mon, 06 Aug 2007 22:36:00 -0000, yovation <yovation@gmail .com>
wrote:

Sounds like you need to create a 3-table join query, base your report
on this query, and select the appropriate grouping levels. The report
wizard can get you started with that.

-Tom.

>Hello,
>
>I have a 3 table product database.
>
>1) Products (Parent)
>2) Attributes (Child)
>3) Options (Child of Child (Attributes))
>
>Here is the problem I am having.
>
>I need a report that looks like this: - The first field of every
>table needs to be displayed in same column.
>
>Product 1
>1st Attribute of Product 1
>1st Option of 1st Attribute
>2nd Option of 1st Attribute
>3rd Option of 1st Attribute
>2nd Attribute of Product 1
>1st Option of 2nd Attribute
>2nd Option of 2nd Attribute
>
>Product 2
>etc......
>
>Thank you.
>yovation