A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Updating Table with a form



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2010, 11:18 PM posted to microsoft.public.access
jamo
external usenet poster
 
Posts: 11
Default 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  
Old May 18th, 2010, 04:24 AM posted to microsoft.public.access
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default 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  
Old May 21st, 2010, 10:35 PM posted to microsoft.public.access
jamo
external usenet poster
 
Posts: 11
Default 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  
Old May 22nd, 2010, 12:07 AM posted to microsoft.public.access
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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.



  #5  
Old May 22nd, 2010, 03:25 AM posted to microsoft.public.access
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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]
  #6  
Old May 25th, 2010, 11:00 PM posted to microsoft.public.access
jamo
external usenet poster
 
Posts: 11
Default 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  
Old June 3rd, 2010, 03:25 PM posted to microsoft.public.access
jamo
external usenet poster
 
Posts: 11
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.