I am needing help with Unique indexing some fields in a table called "Orders".
Sometimes "BobsOrderID" may be filled out and sometimes "JimsOrderID" may be filled out. Sometimes maybe both will be Null. Depends on where the order comes from
I need help determining on how to set these so the order IDs are unique to each field.
BobsOrderID = 12345,12345 BAD
BobsOrderID = 12345,54321 GOOD
JimssOrderID = 12345,12345 BAD
JimsOrderID = 12345,54321 GOOD
BobsOrderID = 12345 AND
jimsOrderID = 12345 GOOD
The Nulls and combinations are throwing me off. I hope this makes sense and thank you for the help.