Eliminate Duplicate Combinations of Records

[multipleintell]

Hey,

I have a table that is linking two other tables. I do not want to have a combination of two fields not be unique. In other words...

FieldA FieldB
red apple
red strawberry
orange orange
yellow banana
green lime
green apple
red apple this is a duplicate combination



I want both fields to allow duplicate records however,...
I don't want a combination to be duplicated.

How do I eliminate this problem?

Thanks you in advance
Melissa

 

[MichaelRed]

introduce an index which is composed of the two fiedls and set it's property to no dup allowed

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over