If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Access newbie needs a mentor
No problem! I've still have those DUH! moments...
-- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Al Taylor" wrote in message ... DUH!!! I should have known that... Foreign Key. Thanks for clearing that up. Al "Gina Whipp" wrote: Al, The purpose of that field is to set up a relationship to the tblEmergencyContact table which you are going to need in order to enter emergency contacts FOR members. FK = Foreign Key and because it is going to relate (link) to mMemberID which is an Autonumber you need it to be a Number. You can't relate a Text field to a Number field. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Al Taylor" wrote in message ... Gina, What is the purpose of this field? I think I understand the relationship piece of this but why the ecMemberID field and what is FK-Number? ecMemberID (FK-Number) -----Add this field and relate to tblMember (Go to Tools-Relationships) Al "Gina Whipp" wrote: Thank you (just giving back) and you're welcome... Come back if you have any problems! -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Al Taylor" wrote in message ... Thank you Gina, You have gone above and beyond the call, I will try what you suggest and let you know the result. Al "Gina Whipp" wrote: Al, Okay, I see the reason you are having an issue linking the two tables... They are not *related* in any way, so let's fix that. This is the Member Table: tblMembers mMemberID AutoNumber (Primary Key) mSuffix Text mFname Text mLname Text mStreet Address Text mAptNumber Text mCity Text mZipCode Text mHomePhoneNumber Text mCellPhoneNumber Text mEmailAddress Text This is the emergency contact Table: tblEmergencyContacts ecEmergencyContactID AutoNumber (Primary Key) ecMemberID (FK-Number) -----Add this field and relate to tblMember (Go to Tools-Relationships) ecEmrFname Text ecEmrLname Text ecEmrHnum Text ecEmrCnum Text I made a few changes to your tables: 1. Removed all spaces from field names. Just make for more work when having to do code. 2. In tblEmergencyContacts you only need on field per contact not Emr1Fname and Emr2Fname. As each record will contain a name going down not across. So now when you make the relationship you will have one to many and each Member can have as many emergency contacts as you like. 3. You may want to include WorkNumber because some folks work Sundays. Your main form will have a RecordSource of tblMembers and format to single form view and the subform will have a RecordSource of tblEmergencyContacts and format to continuous form view. Once you do that you should be able to *alter* data in both forms. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Al Taylor" wrote in message ... Thank you Gina, Thanks for the URL's you included in your reply, I think they will help greatly. I do understand that. This is the Member Table: ID AutoNumber (Primary Key) Suffix Text Fname Text Lname Text Street Address Text Apt Number Text City Text ZipCode Text HomePhoneNumber Text CellPhoneNumber Text EmailAddress Text This is the emergency contact Table: ID AutoNumber (Primary Key) Emr1Fname Text Emr1Lname Text Emr1Hnum Text Emr1Cnum Text Emr2Fname Text Emr2Lname Text Emr2Hnum Text Emr2Cnum Text "Gina Whipp" wrote: Al, As much as we would LIKE to be one-on-one with you how would that be fair to all the others requesting help? This is a volunteer newsgroup and by volunteer I mean... no pay and OUR volunteer time. So, let's move past that... In order for us TO help you please provide the fields in the tables you do have. It does sound like you need a form/subform set-up but not sure how to tell you to set that up without knowing what fields are in your tables. Also, here are some tutorials that might help... Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...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 http://www.databasedev.co.uk/table-of-contents.html -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Al Taylor" wrote in message ... Hello all, I am making this post because I am completely new to access and I have been charged with creating a database for my church. This database is to contain church members and emergency contacts for the members. I have so far created two tables. A members table and an emergency contacts table. I see this as a one to many relationship because one church member may have maybe two or three people to contact in case of emergency (i.e. If I fall ill during a church function, the first person I want you to call is my mother, if she is not avalible then call my brother). I have also created a form but cannot seem todisplay and malipulate data on both tables at the same time. The bottom line is that I am asking for someone to be a mentor for me, to becoma a 'Master Yoda' for me. Please. Signed Al Taylor |
|
Thread Tools | |
Display Modes | |
|
|