Thanks All for the info.
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> As Glenn said, this is a hot topic. I can't remember when I used anything but an AutoNumber. I don't care what the client says either. If they want a natural key such as a meaningful account number consisting of the company initials and 10 padded numbers I tell them okay and then just add that as another field with a unique index.
>
> Advantages of an AutoNumber:
> 1. User can't create it or edit it.
> 2. It is not dependent on another field in the table.
> 3. It is always a long. I don't have to remember the data type when creating a foreign key.
> 4. Indexing on a number field is always faster than indexing on a character field.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Mas Shine <bluesky1174@> wrote:
> >
> > Need advice, what is the best way to create a primary key. is it using
> > autonumber or else ?
> > Please give pro and cons for each option,
> >
> > Thanks in advance
> >
>
Tidak ada komentar:
Posting Komentar