Table Constraint

[Rockape]

Hi,

Grateful for advice

I have a table with different fields, lets say field A and Field B

Field A can have duplicates
Field B is a y/n toggle

I would like a constraint which prevents two records having identical data in those two fields.

Thanks

 

[JANR]

Create a multifield index on the fields :http://www.btabdevelopment.com/ts/mfi

JR