I need to put

NOT EXISTS(SELECT * FROM [TICKETS] WHERE [VOID] = [TICKET])

Into a constraint. So that the chained tickets do not form a loop.