Getting Material Part Revision onto BOM List Query

[mjf1143 (Michael Foreman)]

I solved it. Had to create another InnerSubQuery to get the max revision and do a left join with the TopLevel.

Thanks for your input.