Hi Sean,
Look at using Common Table Expressions (CTE) Here is a rough sample based on your details
Thank you for the pointer to CTE and the example.I have only looked at CTE briefly once before (for representing tree structures), so it will take me some time to do some reading and to dissect your example.
BR Mike
