Validate Order

as per what you explained you just need a EXISTS condition chek with Order table to make sure OrderID value is not existing already

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page