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-a83fa5a829dcJust 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?
If it's not broken, fix it until it is.
My Blog