I recommend creating an IDENTITY column in the parent table requiring the Order Number. Let SQL Server do the work in calculating the next value. The process of...