Re: [GENERAL] Constraint for two fields unique any order

[MargaretGillon]

Hi Richard and list,

Thanks for the reply. On the constraint what I am trying to create is a constraint that would not let me create a row with fkey1 = 4 and fkey2 = 10 if I already had a row that had fkey1 = 10 and fkey2 = 4.  The constraint needs to check the combination of values in any order.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297