January 11, 200818 yr Newbies 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.
January 17, 200817 yr Author Newbies Thank-you for your assistance. This was the answer I was looking for.
Create an account or sign in to comment