> On Wed, 2006-07-19 at 09:01 -0700, [EMAIL PROTECTED]
wrote:
> > I have a junction table that is recording relationships between
two
> > records in another table. Is there a way that I can create a
> > constraint so that the values are not repeated in any order?
I want to
> > make sure that rows
On Wed, 2006-07-19 at 09:01 -0700, [EMAIL PROTECTED] wrote:
> I have a junction table that is recording relationships between two
> records in another table. Is there a way that I can create a
> constraint so that the values are not repeated in any order? I want to
> make sure that rows such as 2 a
On Wed, 19 Jul 2006 [EMAIL PROTECTED] wrote:
> I have a junction table that is recording relationships between two
> records in another table. Is there a way that I can create a constraint so
> that the values are not repeated in any order?
I think the following does what you need, though my "f
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.
> I have a junction table that is recording relationships between two
> records in another table. Is there a way that I can create a constraint so
> that the values are not repeated in any order? I want to make sure that
> rows such as 2 and 4 in the example below cannot happen. This is a very
