[AccessD] Compound Unique Keys...Again

[John W. Colby]

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