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

Printing all subform data records

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

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


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

Nov 13 '05 #2

P: n/a

"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
Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

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

Nov 13 '05 #5

P: n/a
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
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.