Re: A philosophical newbie issue: catch redundant errors via relationships or programmically?
Date: Mon, 31 Dec 2007 19:13:09 GMT
"David Cressey" <cressey73_at_verizon.net> 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.
>I could be wrong, but I don't think Access has any particular limitations in
I did an Access database using compound keys back in A2.0 in about 1995 or so. If anything it works a bit better these days.
-- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/Received on Mon Dec 31 2007 - 13:13:09 CST