Hi,
I am designing a vocabulary database. I want to create relationships between words within the database, so I make a junction table, add two fields (Word1, Word2) and another field for relations.
I want to avoid the situation in which a word pair, for example (Word1 = A; Word2 = B) is accidentally repeated in reverse order (Word1 = B; Word2 = A). Since each word pair only has one relationship, the combination of (A, B) is the same as (B, A), but Access wouldn't know it. It recognizes these as two distinct records.
How to avoid this situation? Maybe a Before Change Event of some sort?
I am designing a vocabulary database. I want to create relationships between words within the database, so I make a junction table, add two fields (Word1, Word2) and another field for relations.
I want to avoid the situation in which a word pair, for example (Word1 = A; Word2 = B) is accidentally repeated in reverse order (Word1 = B; Word2 = A). Since each word pair only has one relationship, the combination of (A, B) is the same as (B, A), but Access wouldn't know it. It recognizes these as two distinct records.
How to avoid this situation? Maybe a Before Change Event of some sort?