Re: A philosophical newbie issue: catch redundant errors via relationships or programmically?
Date: Sun, 30 Dec 2007 11:03:27 -0400
> On Dec 29, 5:42 pm, Marshall <marshall.spi..._at_gmail.com> wrote:
> Thanks. I could not get the compound key to work in Access, which is
> a bit strange (the restriction on whether a foreign key is a duplicate
> or is unique is rather hidden). After many permutations, I gave up,
> but it could be a peculiarity of Access.
Having read over your original question again, it seems you are trying to declare a uniqueness constraint as a foreign key reference.
I don't know the specifics in Access, but 'uniqueness constraint', 'alternate key', 'unique index' etc. are some likely candidates to look for. Received on Sun Dec 30 2007 - 16:03:27 CET