check duplicates

[maravinds]

hai everyone,

i have a table with 5 columns (all of them are text) and i need to check that the combination (combined value) of 3 columns does not get repeated.

how is this possible



aravind.s

 

[wazz]

make those three your primary key.

 

[maravinds]

hai,
i cannot make the three values as a primary key because i have an autonumber column which is set as a primary key

 

[wazz]

how about creating an index?
- open your table in design view.
- click indexes on the menu (the button with the lightning bolt)
- on an empty line under Index Name type NoDups; at the bottom (properties): Primary: No; Unique: Yes; Ignore Nulls: up to you.
- under Field Name (beside NoDups) select the three fields you want:

NoDups    Fld1
          Fld2
          Fld3

- if you have duplicates then you have to fix the data first (i think).

- without seeing what you're up to i can't say that this is the best approach but maybe it will help for now.