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]

On Mon, 06 Aug 2007 22:36:00 -0000, yovation <yo******@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