Automatically add items to a "pick list"

[Wayne0412]

Hello all, Firstly, I am sorry if this question has been answered elsewhere, but I wasn't sure which search terms to use to find the answer.

I am trying to develop a sales solution that will pull stock from an inventory module and create a list of equipment that the client has asked for. My question is, how do I get FM to automatically add items to a pick list based on a particular code?

Let me explain...

I want to type in a product code, for example, "10m steel pole".

The "10m steel pole" ships with 4 x "M10 Bolts" and 2 x "fixing plates". I want the bolts and the plates to be automaticall entered into the pick list when I select the pole code.

Obviously, if I choose 10 x poles, I will need 40 x bolts and 20 x plates.

Any help would be geatly appreciated.

I use FMP10 and Win 7.

Cheers

[Lee Smith]

Are these a package? In other can they only be only sold as stated, 10 poles or 40 bolts and 20 plates, or can they be purchase separately?

Lee

[Wayne0412]

Thanks Lee,

I think my answer to your question is both. They would be sold as a package - if that pole was sold, there would always be that quantity of bolts and base plates sold with it.

I will still need to be able to sell the bolts and the plates separately and account for each individual stock item in the "on hand" count.

WT

[Wayne0412]

Hi Lee,

Did my last response make sense? Can I put it another way? I would really love to resolve this if possible.

Thanks in advance (again).

[David Jondreau]

Don't know what tables you already have, but I think you'll need a couple more tables. One for "Packages" and one for "Package Inventory Join". Packages will have records like "Pole package". The Join table will be records that have the Package ID and the Inventory ID, in this case three records, one each for pole, bolts, and plates. The Join table can also have a Quantity field, 1 for Pole, 4 for Bolts, 2 for Plates.

Script it so when Package is chosen, the quantity of that package multiples the Quantity in the Join.