Duplicates Problem in Concatenated fields

DblDogDare

Registered User.
Local time
Today, 14:18
Joined
Feb 14, 2003
Messages
17
I have a table with two fields ECP and Rev. Duplicates are OK in each field, but not when concatanated. Is there any way to "No Duplicates" on combined fields in a table? I have queries , forms, etc., that concatanate these, but I am finding that my users are duplicating. Any help is greatly appreciated.
 
Problem Solved

I figured it out. I found the fix an another forum. I created an index on the 2 fields.
 

Users who are viewing this thread

Back
Top Bottom