>>>Terminology: it might depend on the purpose:
>>>
>>>- Assembly - implies a group of parts, normally sold individually, that are sold put together (assembled)
>>>
>>>- Kit - implies a group of parts, normally sold individually, that are sold as a group of loose parts (unassembled)
>>>
>>>- Bundle - implies a group of parts, normally sold individually, that are sold at a discount to the sum of the prices of the individual component prices. May be assembled or not
>>>
>>>Data structure - if you're going to support BoMs, make sure you support unlimited level/recursive BoMs. If you only support one or two levels, for sure some bright marketing spark is going to want to use more levels, so you may as well support unlimited from the get-go. There are lots of resources on the web discussing data structures supporting multi-level BoMs.
>>
>>Thanks Al,
>>
>>I guess Bundle is the closest match for my purpose.
>>
>>So would you describe this as a BoM? I guess it's pretty close so I'll check google that.
>
>Check this sample (SQL 2000)
>http://beyondrelational.com/justlearned/posts/628/recursive-bom-implementation-for-older-version-of-sql-server.aspx

Thanks Naomi, but this is a VFP database.