I remember you helping me with a similar solution - but that was one recursively deleted child nodes in a TreeView.....

>A bit unrelated, but I was solving yesterday a BOM problem for SQL 2000
>
>http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/cec3473b-44ee-4dca-8f2a-a83fa5a829dc
>
>Just in case someone wants a recursive BOM implementation for older version of SQL - easier in SQL 2005+ with recursive CTEs.
>
>>>>>>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?