Relationship Challenged

[jtomb]

I’m a newbie and I am stuck.

I have created a simple inventory database with a twist. I allow parts to put into packages. Ie. say you have part A, part B and part C, you might create part D which is comprised of some quantity of part A, B, and/or C or any combination thereof. I do this with a parent / child relationship and all is good.

I have created a line item invoice database which allows me to select the parts from the inventory database and add them to the invoice – still nothing to fancy.

I have 2 problems:

1. On my invoice, I would like to have an option to display what parts are included in a package.

2. I need to create a list of materials to ship, so I need to convert my packaged parts back to parts with the appropriate quantities.

I can’t figure this out; any guidance would be greatly appreciated.

[bcooney]

I would read this. Recursive Data Structures- by Jonathan Stark

[jtomb]

Thank-you for your assistance. This was the answer I was looking for.