By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,136 Members | 1,614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,136 IT Pros & Developers. It's quick & easy.

Combine data for report - Problems with column / rows

P: n/a
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

Aug 6 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Aug 7 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.