Printing all subform data records

[Paul]

I have a simple database - 3 fields (Parent,Component,Qty)
and I link this table to itself using Master File Parent and Link File
Component.

This creates a multi-indented table which I would like to get to a
sequential file with all levels of the Master File listed.

Example:

Master File

Item 1->Component1
Item 1->Component2
Component2.1->Component2.1.1
Component2.2->Component2.2.1
Component2.3->Component2.3.1
Component2.4->Component2.4.1
Component2.4.1->Component2.4.1.1
Component2.4.2->Component2.4.2.1
Component2.4.3->Component2.4.3.1
Item 1->Component3
Component3.1->Component3.1.1
Component3.2->Component3.2.1
Component3.3->Component3.3.1
Component3.4->Component3.4.1
Item 1->Component4
Component4.1->Component4.1.1
Component4.2->Component4.2.1
Item 1->Component5

When I add a subdatasheet to the master file I am able to expand the
database to see all records at any level - that is when I click on a
component its components are listed.

I must be missing something when I tried to add a sub/form to my report
that will list all records at all levels.
Is there a link that would explain it.

[Phil Stanton]

Sounds a bit like a recipe db that I wrote where each recipe consisted of
ingredients + other recipes.

E.G. A Steak & Kidney pudding consists of a pudding Recipe, A Gravy Recipe,
Steak ingredient, Kidney Ingredient, Salt, Pepper. The Pudding recipe
consists of Flour, water, salt etc.
No limit to the depth of recipes and sub recipes

Any help

Phil

P.S. You may realise I am no cook.
"Paul" <pp******@glcomputers.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

I have a simple database - 3 fields (Parent,Component,Qty)
and I link this table to itself using Master File Parent and Link File
Component.

This creates a multi-indented table which I would like to get to a
sequential file with all levels of the Master File listed.

Example:

Master File

Item 1->Component1
Item 1->Component2
Component2.1->Component2.1.1
Component2.2->Component2.2.1
Component2.3->Component2.3.1
Component2.4->Component2.4.1
Component2.4.1->Component2.4.1.1
Component2.4.2->Component2.4.2.1
Component2.4.3->Component2.4.3.1
Item 1->Component3
Component3.1->Component3.1.1
Component3.2->Component3.2.1
Component3.3->Component3.3.1
Component3.4->Component3.4.1
Item 1->Component4
Component4.1->Component4.1.1
Component4.2->Component4.2.1
Item 1->Component5

When I add a subdatasheet to the master file I am able to expand the
database to see all records at any level - that is when I click on a
component its components are listed.

I must be missing something when I tried to add a sub/form to my report
that will list all records at all levels.
Is there a link that would explain it.

[Darryl Kerkeslager]

"Phil Stanton" <di********@stantonfamily.co.uk> wrote:

E.G. A Steak & Kidney pudding consists of a pudding Recipe, A Gravy Recipe, Steak ingredient, Kidney Ingredient, Salt, Pepper. The Pudding recipe
consists of Flour, water, salt etc.

That's just nasty.

Darryl Kerkeslager

[Bas Cost Budde]

Darryl Kerkeslager wrote:

"Phil Stanton" <di********@stantonfamily.co.uk> wrote:

E.G. A Steak & Kidney pudding consists of a pudding Recipe, A Gravy

Recipe,

Steak ingredient, Kidney Ingredient, Salt, Pepper. The Pudding recipe
consists of Flour, water, salt etc.

That's just nasty.

It depends on the relative amount! Pudding with no salt at all can be
very annoying, or even dusty.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[Darryl Kerkeslager]

I meant the kidneys!

Darryl Kerkeslager
"Bas Cost Budde" <b.*********@heuvelqop.nl> wrote:

Darryl Kerkeslager wrote:

"Phil Stanton" <di********@stantonfamily.co.uk> wrote:

E.G. A Steak & Kidney pudding consists of a pudding Recipe, A Gravy

Recipe,

Steak ingredient, Kidney Ingredient, Salt, Pepper. The Pudding recipe
consists of Flour, water, salt etc.

That's just nasty.

It depends on the relative amount! Pudding with no salt at all can be
very annoying, or even dusty.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[Trevor Best]

Darryl Kerkeslager wrote:

I meant the kidneys!

Very popular in the UK. I'm in the same camp as Crocodile Dundee on that
one, you can live on it, but it tastes like shit.

Man: Steak and Kiddly pie please.
Shop Assitant: Don't you mean Steak and Kidney?
Man: I said that diddle I?

--
This sig left intentionally blank