Hi all again,
Good day.
I need help in Ms Access, i dont know where this should be place, at the table? or at the code?
Say i have 5 fields and all of those fields can be duplicated but, once 3 fields from those 5 fields be duplicate the system will popup an error.
Field1 = Duplicate OK
Field2 = Duplicate OK
Field3 = Duplicate OK
Field4 = Duplicate OK
Field5 = Duplicate OK
But Field1 & Field4 & Field5 in a row should not be duplicated.
Am I thinking possibilities on this?
Thank in advance.
Cheers
abs
Good day.
I need help in Ms Access, i dont know where this should be place, at the table? or at the code?
Say i have 5 fields and all of those fields can be duplicated but, once 3 fields from those 5 fields be duplicate the system will popup an error.
Field1 = Duplicate OK
Field2 = Duplicate OK
Field3 = Duplicate OK
Field4 = Duplicate OK
Field5 = Duplicate OK
But Field1 & Field4 & Field5 in a row should not be duplicated.
Am I thinking possibilities on this?
Thank in advance.
Cheers
abs