Just wanted some advice...
I have some Data on PartNumber supercessions which i'd like to store for future use
data is essentaly...
Part1 --> Part2 -->Part3 -->Part4
length of chain varies..
I want to be able to store this... but also highlight the "latest" Part Number..
so essentialy im able to query my database.. say, Part2, the answer i end up with is Part4
ChainID / Part / Latest
001 Part4 Y
essentialy i could query the Part - get the chainID, then get the latest Part? (y)
does this structure make sense - or is there a more effective way of storing
this will eventualy contain around 200k part numbers, say 75k "chains"