Re: A philosophical newbie issue: catch redundant errors via relationships or programmically?

"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
>this regard.

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

-- 
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/