I am working on a Parts database.

Any given part can be an assembly, made up of other parts.

I have a Parts table and an Assembly table, as the middle table.

I need to print out a work order that shows Parts and for assemblies, the Parts that make up the assembly. The problem is when there is more than one level of Hierarchy:

Part A

Part B

Part B-1

Part B-2

Part B-3

Part B-3-a

Part B-3-b

Part B-4

Part C

Part C-1

Part C-1-a

Part C-1-b

Part C-2

Part C-3

Part C-3-a

Part C-3-b

Any help on how to set up a layout to show me something similar to the above?

Let me know if I need to clarify anything. Thanks in advance!

What you ask for is, in typically geeky understatement, referred to as "non-trivial".

There have been some recent posts with issues similar to yours, it could be worth searching the forums.

You could get Seedcode Hierarchy:

http://www.seedcode.com/cp-app/ste_cat/schierarchy

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/190208/post/268238/#268238

http://fmforums.com/forum/showtopic.php?tid/192677/