how can I generate an indented bom with microsoft access

how can I generate an indented bom with microsoft access
vernalwayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Couple different methods:

1. SQL Approach
2. VBA based approach.

  I would start by taking a look at this:

Expanding a Hierarchical Data Structure
http://www.experts-exchange.com/Database/MS_Access/A_19-BOM-parts-list-expansion.html

 which will give you a good start.   let me know if you have any questions on the article.

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
And keep in mind that this is only one way to structure this, although most solutions fall along these lines; a part master, then a BOM table with each level of the BOM entered individually.

 For example, I have a VBA sample that doesn't use recursion.   Others do BOM editing using a tree view control so you can see the entire structure, etc.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vernalwayAuthor Commented:
Thanks a lot Jim!  That gets me going nicely with the example of a recursive routine.  I'll be implementing today.
0
vernalwayAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for vernalway's comment #a40335182

for the following reason:

Problem solved.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Welcome to EE.  Glad to hear that helped you along.

Given that, assuming you made a mistake in choosing your own comment as the solution for the question (everyone does this at first because it's so easy just to pick the last comment), so I'm going to object to the close.

That will allow things to be closed properly.

Jim.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.