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

"raylopez99" <raylopez99_at_yahoo.com> wrote in message news:b722df4a-56b2-4f74-aca3-12813610c1b2_at_l32g2000hse.googlegroups.com... 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.

I could be wrong, but I don't think Access has any particular limitations in this regard.

I'm not sure what you mean by "foreign key is a duplicate" or by "many permutations".

RL Received on Mon Dec 31 2007 - 11:58:12 CET