I just wanted to start by saying thank you to whom-ever might be able to help me out here. I'm a veteran and I work as a volunteer for a Veteran Services office for a small community college, being that I'm the most computer litterate person in the office I got tasked with building a database to store all of our veteran students information. Now I have taken a basic access class before but it was quite some time ago and I have largely forgot a lot about relationships and such. So on to my problem here, lol, the current issue that I'm having is that I have one table set up as a Student information table, this table houses all the students information relating to contact info, i'm wanting to make a data entry form with buttons at the bottom of the student information form saying something like Chapter 33 which is the Post 9/11 GI Bill for veteran students. By clicking this button it will take them to the form that I made from the Chapter 33 table. When I try to link the 2 tables together via a relationship it is giving me a one-to-one relationship, I'm not understanding why this is. I have the SSN# set as the primary key for the student information table, and i have tried using the student ID as a primary key for the chapter 33 table but still gives me a one to one relationship when i'm trying to link the SSN# fields. Pretty much what I'm wanting to do is as the data entry person is inputting the info on the student info form the click the chapter 33 button and it will pull up the chapter 33 form searching by SSN# to see if an entry has already been made under that SSN# if so it will populate the fields/check boxs if not then it will create a new record for the chapter 33 form with the students name and SSN# populated from the student information form. I really hope this makes since I'm attaching a copy of my database with as far as I've got so far, and I guess we will see what happens. Sorry if this is confusing and if anyone needs more info please feel free to ask.
I'm going to try and upload my database so those who are willing to help a completely lost and out of his element guy, can take a look, THANK YOU AGAIN!
Tidak ada komentar:
Posting Komentar