We use Syspro as our ERP System. The data is stored in a sequel DB.
The table contains the Parent Part and its components - the problem is that some components must be exploded further to get to the lowest level of the BOM which is called the Buy out level.
So what i need at the end is a table with the parent and all its components where the part category = B - this replacing all components that are <> part category B by their components hence if the components part category <>B it becomes a parent etc
It all sounds to much like a circular reference for my brain - Any ideas?