Kyle
By using an AutoNumber for the address table's PK, you just use that in the related tables instead of having to put in the actual address in those tables. Think of all the wasted time and all the possible typos every time that field has to be filled in.
You really should read Crystal's book. It does a great job of explaining relationships and how they work.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <kyleemert@gmail.com> wrote :
Hi Crystal,
Thanks for the quick reply. I'll check out those videos but I do have a quick question, why would I add an AddressID autonumber to be the PK in the Address table instead of using the actual Address as the PK? Sorry for the noob question.
Kyle
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Yahoo Groups
Instantly Explore All Attachments Within Each Group Conversation
You can now explore files, preview and download photos directly within each conversation.
.
__,_._,___
Tidak ada komentar:
Posting Komentar