>>>>>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?

I suggest that you keep a separate table for the kits, and give each kit an unique id. So for a kit of four different articles, this table will have four records with the same id.