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 |
|
#1
|
|||
|
|||
Updating Table with a form
-- Center for technica education I have Two Tables ,a Student Name Table with Two Fields, Student Id and Student Name the other table is a Rubic Table and has the same two fields along with other fields. I have created a form with a combo box(Names) on the form and I am trying to get the Name and the Student Id to be entered into the into the Rubic Table fields but I can't seem to get the Student Id to be entered. I know I am doing something stupid but I can't seem to make it work. Thank you in advance for all the help. You guys are great. |
#2
|
|||
|
|||
Updating Table with a form
On Mon, 17 May 2010 15:18:01 -0700, Jamo
wrote: You have an incorrect database design. The StudentName field should only be in the Students table. Then creating a dropdown which now only has to populate tblRubic.StudentID is simple. -Tom. Microsoft Access MVP I have Two Tables ,a Student Name Table with Two Fields, Student Id and Student Name the other table is a Rubic Table and has the same two fields along with other fields. I have created a form with a combo box(Names) on the form and I am trying to get the Name and the Student Id to be entered into the into the Rubic Table fields but I can't seem to get the Student Id to be entered. I know I am doing something stupid but I can't seem to make it work. Thank you in advance for all the help. You guys are great. |
#3
|
|||
|
|||
Updating Table with a form
Tom:
Thank you for the replay ,however the reason that I have both the Student Id and the student name in the form is that the teacher entering the data does not know the student id but does know the students name.The reason the the student Id is there also in case two student have the same name. Can I do it?? -- Center for technica education "Tom van Stiphout" wrote: On Mon, 17 May 2010 15:18:01 -0700, Jamo wrote: You have an incorrect database design. The StudentName field should only be in the Students table. Then creating a dropdown which now only has to populate tblRubic.StudentID is simple. -Tom. Microsoft Access MVP I have Two Tables ,a Student Name Table with Two Fields, Student Id and Student Name the other table is a Rubic Table and has the same two fields along with other fields. I have created a form with a combo box(Names) on the form and I am trying to get the Name and the Student Id to be entered into the into the Rubic Table fields but I can't seem to get the Student Id to be entered. I know I am doing something stupid but I can't seem to make it work. Thank you in advance for all the help. You guys are great. . |
#4
|
|||
|
|||
Updating Table with a form
On Fri, 21 May 2010 14:35:01 -0700, Jamo
wrote: Tom: Thank you for the replay ,however the reason that I have both the Student Id and the student name in the form is that the teacher entering the data does not know the student id but does know the students name.The reason the the student Id is there also in case two student have the same name. Can I do it?? The student *name* should only be in the student table. That doesn't mean it can't be on the form! The form is just a window, a tool; it's not the table. Normally one would have a Student table with a unique StudentID, LastName, FirstName, *and other identifying information*. On the Form you would have one or more combo boxes, bound to the StudentID, displaying the name and (when dropped down) other identifying information - grade or class name, home address, StudentID, whatever is useful in your circumstances. in your example... if the teacher doesn't know the ID, what help is it to have two records in the form both showing Mike Smith? -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Updating Table with a form
Jamo,
I concur with Tom that your design of the tables is incorrect. Please explain what the fields beside student name and StudentID are in the Rubic table so I can suggest a better design of your tables. Are the Rubic rable fields dated so you enter them throughout the school year? Steve "Jamo" wrote in message news -- Center for technica education I have Two Tables ,a Student Name Table with Two Fields, Student Id and Student Name the other table is a Rubic Table and has the same two fields along with other fields. I have created a form with a combo box(Names) on the form and I am trying to get the Name and the Student Id to be entered into the into the Rubic Table fields but I can't seem to get the Student Id to be entered. I know I am doing something stupid but I can't seem to make it work. Thank you in advance for all the help. You guys are great. |
#6
|
|||
|
|||
Updating Table with a form
The Rubic data is updated on a weekly basis and I have a field for the week
ending.To answer Tom's question,if the teacher does not know the student id,why is it there.The reason is that if the teacher sees two students with the same name,it will be a flag to go and find what the students id are.I do have a student name table with their id and names. I guess I took the easy route.Being new to access I was not sure how to do what Tom is recommending.How would I do what you are suggesting Tom Center for technica education "Steve" wrote: Jamo, I concur with Tom that your design of the tables is incorrect. Please explain what the fields beside student name and StudentID are in the Rubic table so I can suggest a better design of your tables. Are the Rubic rable fields dated so you enter them throughout the school year? Steve "Jamo" wrote in message news -- Center for technica education I have Two Tables ,a Student Name Table with Two Fields, Student Id and Student Name the other table is a Rubic Table and has the same two fields along with other fields. I have created a form with a combo box(Names) on the form and I am trying to get the Name and the Student Id to be entered into the into the Rubic Table fields but I can't seem to get the Student Id to be entered. I know I am doing something stupid but I can't seem to make it work. Thank you in advance for all the help. You guys are great. . |
#7
|
|||
|
|||
Updating Table with a form
I took all you folks advice and revised my tables and followed you
suggestions and the good news is that I go twhat I wanted. Thanks to all of you,good job.Thank you so much. -- Center for technica education "Jamo" wrote: The Rubic data is updated on a weekly basis and I have a field for the week ending.To answer Tom's question,if the teacher does not know the student id,why is it there.The reason is that if the teacher sees two students with the same name,it will be a flag to go and find what the students id are.I do have a student name table with their id and names. I guess I took the easy route.Being new to access I was not sure how to do what Tom is recommending.How would I do what you are suggesting Tom Center for technica education "Steve" wrote: Jamo, I concur with Tom that your design of the tables is incorrect. Please explain what the fields beside student name and StudentID are in the Rubic table so I can suggest a better design of your tables. Are the Rubic rable fields dated so you enter them throughout the school year? Steve "Jamo" wrote in message news -- Center for technica education I have Two Tables ,a Student Name Table with Two Fields, Student Id and Student Name the other table is a Rubic Table and has the same two fields along with other fields. I have created a form with a combo box(Names) on the form and I am trying to get the Name and the Student Id to be entered into the into the Rubic Table fields but I can't seem to get the Student Id to be entered. I know I am doing something stupid but I can't seem to make it work. Thank you in advance for all the help. You guys are great. . |
Thread Tools | |
Display Modes | |
|
|