Relationships
in [Tables]
|
From: Boating 89 on 14 Mar 2010 16:44 New to Access and using version 2007. I am building a database covering the membership of a boating club. Looking at tables that would include: * Primary Members Data - all members in the Club - type of membership, year joined/left and similar. One record per member (so spouses/partnerships have two line items) * Members Contact Data - address and similar - again one line item per member * Members Boats Names and specifics * Members history with the Club - membership class per year for past 25 years And so on. My question is the confusion of setting up the relationships and these primary and foreign (or child they call it evidently) ID numbers. Every member has an assigned "Member Number" - should that be the primary key. Is the Member Number what you link between these relationship tables? As whomever reads this can likely tell I am very confused on how to assign relationships. And then these "Lookups" come into play. Any help that anyone can provide would be much appreciated. I have attempted to find this info anywhere without success. Thank you. -- Thank you for all your help. Joysea
From: Gina Whipp on 14 Mar 2010 20:59 Boating 89, This should help... * Primary Members Data - all members in the Club - type of membership, year joined/left and similar. One record per member (so spouses/partnerships have two line items) tblMembers mMemberID - PK mFirstName mLastName etc... tblMemberContactInformation mciMemberID - FK - link to tblMembers mciAddress1 mciAddress2 mciCityName mciState mciPostalCode etc... tblMemberVehicles mvMemberID = FK - link to tblMembers mvBoatID mvBoatName etc... Not sure what the below is, so not sure of table name or if it even needs a separate table. * Members history with the Club - membership class per year for past 25 years Since it sounds like you are new to this, here's some suggested readings... Jeff Conrad's resources page... http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page... http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP)... http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials... http://allenbrowne.com/links.html#Tutorials Sample data models... http://www.databasedev.co.uk/table-of-contents.html -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Boating 89" <Boating89(a)discussions.microsoft.com> wrote in message news:A622E214-427D-4A4B-9DDA-828EC225B34C(a)microsoft.com... New to Access and using version 2007. I am building a database covering the membership of a boating club. Looking at tables that would include: * Primary Members Data - all members in the Club - type of membership, year joined/left and similar. One record per member (so spouses/partnerships have two line items) * Members Contact Data - address and similar - again one line item per member * Members Boats Names and specifics * Members history with the Club - membership class per year for past 25 years And so on. My question is the confusion of setting up the relationships and these primary and foreign (or child they call it evidently) ID numbers. Every member has an assigned "Member Number" - should that be the primary key. Is the Member Number what you link between these relationship tables? As whomever reads this can likely tell I am very confused on how to assign relationships. And then these "Lookups" come into play. Any help that anyone can provide would be much appreciated. I have attempted to find this info anywhere without success. Thank you. -- Thank you for all your help. Joysea
|
Pages: 1 Prev: Items table Revisited Next: Building cascading lookups in an Access 2007 table |