On Wed, Apr 24, 2013 at 10:53 PM, Gary Jeurink <g.jeur...@charter.net>wrote:
> > At the point where I generate the billing, the index I want in place would > not allow an insert command to duplicate a billing for that > student/class/session. I just assumed unique meant only 1 allowed per > table. > > It's a common misunderstanding. CANDIDATE and PRIMARY keys only allow unique values. UNIQUE are an old remnant of a quirky FoxPro behavior and should NEVER be used. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4udz6q-ko1Xf8JRjDi87x464h0=guwuppd7vk6p8cx...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.