Re: [MS_AccessPros] Best Way to Create Primary key

 

Hi Mas,

My personal preference is AutoNumber (which is Long Integer data type).  I state my main reasons to use artificial keys in this video:

Learn Access -2.B- Planning a Database (Ken Gaines "Pool) - (cc)

http://www.youtube.com/watch?v=mRvwRBEgD2U

this video is also about relationships

Tip： Enforce Referential Integrity on Access Relationships #mstips @MSvideotips.mp4
http://www.youtube.com/watch?v=_zxxc9jzWEg

Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *

________________________________
From: Mas Shine

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

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 5
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___