svanduffelen 83303 (4/27/2015)
I need to putNOT EXISTS(SELECT * FROM [TICKETS] WHERE [VOID] = [TICKET])
Into a constraint. So that the chained tickets do not form a loop.
This needs to be refined. The third row of your sample data (2,1) would violate it.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.