[AccessD] Compound Unique Keys...Again

[Paul Hartland]

I can LOL now....but was scratching my head for hours on this once,
followed by (when I realised what I had done) a selfie slap of the head and
mumbled cursing to myself lol.....

On 3 April 2015 at 04:45, John W. Colby <jwcolby at gmail.com> wrote:

> LOL, good one.  That would definitely kill the uniqueness factor.
>
> John W. Colby
>
> On 4/2/2015 10:33 PM, Paul Hartland wrote:
>
>> Charlotte,
>>
>> So you have a table which has a unique key on one or more fields ?...If so
>> one of these isn't an autonumber is it ? (done this myself in the
>> past...banged head against wall many time for school boy errors like this)
>>
>> Paul
>>
>> On 2 April 2015 at 18:24, Charlotte Foust <charlotte.foust at gmail.com>
>> wrote:
>>
>>  I know that John.   The autonumbers is used strictly  for joins.   Today
>>> ,
>>> on my machine it's working perfectly and as I world expect. Yesterday, on
>>> their machine it didn't.  That pounding you may hear is my head meeting
>>> the
>>> wall.
>>> On Apr 2, 2015 8:43 AM, "John W. Colby" <jwcolby at gmail.com> wrote:
>>>
>>>  If you have a unique id and you are getting "duplicates" then the key
>>>> isn't truly unique.  All making it a PK does is set a unique ID.
>>>>
>>>> John W. Colby
>>>>
>>>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com