>>>>Hi,
>>>>
>>>>although this is a VFP application, the problem is not really VFP related. Currently I have items that can be sold and multiple of those items can be added to an invoice (invoice line items). I want to allow the user to combine multiple of those items into one item that can then be sold with its own unique price (which is not necessarily a sum of all the prices of the individual components). What terminology is used to describe this? I'm thinking Bill Of Materials, but that doesn't "feel" quite right.
>>>>
>>>>I am guessing that the data structure I need to implement is like this:
>>>>
>>>>
Items>>>>ItemId
>>>>ItemDescription
>>>>ItemPrice
>>>>
>>>>
ItemsSub>>>>ItemsSubId
>>>>ItemId
>>>>ItemQty
>>>>
>>>>Does that make sense?
>>>
>>>Bot sure about your data structure but I think I'd describe it as a package as your pricing is a repackaging of an existing tariff.
>>
>>Thanks, package may not work in this case (Optical Labs), I wonder if something like "Combined Items" might :)
>
>Also bundle is often referred to a bunch of linked items in a promotion
Ah, that might be a good term to use!
Now who wants to comment on the data design?