We are currently using a (4) database sales and inventory system based on a Filemaker 4 template. The databases include: Invoices, Products, Purchase and Product Sale Line Item. We have modified the templates over the years to cover a number of inventory control issues but we are wrestling with a new problem that has us stumped.
Some of the products we carry are combinations of other products. For example, a 25' light string with blue bulbs is a combination of (2) products. (A 25 light stringer and a box of 25 blue bulbs. A 100 light stinger "set" would come with (4) boxes of 25 bulbs.) We sell other combinations using the same light stringer with different color bulbs... Each combination has a different item number. We would like the system to be able to recognize the combination and deduct the appropriate number of items sold from the individual component products. Any suggestions will be appreciated.
Thanks,
Steve
Some of the products we carry are combinations of other products. For example, a 25' light string with blue bulbs is a combination of (2) products. (A 25 light stringer and a box of 25 blue bulbs. A 100 light stinger "set" would come with (4) boxes of 25 bulbs.) We sell other combinations using the same light stringer with different color bulbs... Each combination has a different item number. We would like the system to be able to recognize the combination and deduct the appropriate number of items sold from the individual component products. Any suggestions will be appreciated.
Thanks,
Steve