CREATE UNIQUE INDEX FROM MULTIPLE DATABASE COLUMNS
CAN ANYONE HELP ME WITH THIS ISSUE
HAVE DATABASE THAT HAS 2 NUMERIC FIELDS - RECORD NUMBERS FROM OTHER DATABASES, I WOULD LIKE TO COMBINE THESE TWO FIELDS TO PREVENT DUPLICATES
EXAMPLE
FIELD1 FIELD2 EFFECTIVE KEY
1000 66 100066
2000 900 2000900
1000 66 FAIL DUPLICATE KEY
OR IS THERE AN ALTERNATIVE SOLUTION.