This is my first post, so please excuse me if I'm asking something that has already been asked.
I have a table that's used to store parent-child relationships for a multi-level bill of materials. We'll call the table 'BOM'. In this table there are a handful of columns, but the ones critical to this question are "ParentID" and "ChildID".
I have a list of part numbers that I need to get all the "Top-Level" (no parents) part numbers that the initial list of parts numbers are used in.
I found this topic on this site, which might be what I'm looking for, but I'm having a hard time applying it to my situation.
Any help would be greatly appreciated,