my record got OrderFormNo and CashBillNo.(one to one insert)
if 1st record OrderFormNo is 123 and CashBillNo is ABC, if 2nd record also same OrderFormNo, the CashBill must be same.
As a result, I want detect if got same OrderFormNo in database but different CashBillNo, will not insert to database.
Jump to Post
Your post is a little confusing. Let me paraphrase to see if I understand what you're after.
1. You have a table that includes two columns: OrderFormNo and CashBillNo.
2. You have a row in the table with values OrderFormNo=123 and CashBillNo='ABC'.
3. You want to make sure that every …
All 8 Replies
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.