View Single Post
  #2  
Old April 20th, 2010, 03:38 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Form not carrying names to table behind the subform.

On Mon, 19 Apr 2010 18:56:01 -0700, Gil Silva
wrote:

I have a subform linking to a tbl_class. The tbl_class has an ID, LastName,
FirstName, and ClassDate. ClassDate is date completed. (Access 2003)
The relationship is one on the main form to many on the subform. The ID is
populated from the main form and the ClassDate is entered.
However, the LastName and FirstName does not carry over from the main form.
I must be doing something wrong?


Just your expectation.

Relationships do NOT copy data from one table to another. That's not what
they're for and not how they work.

People leave the organization every three years or so. They take many
classes and their names should remain in the tbl_class for historical and
validation purpose.
How can I get the LastName and FirstName to populate the tbl_class after I
have entered the ClassDate but before I move onto the next record?
Appreciate any help!


Why do you want to store the names redundantly in a second table??? The name
should exist in a Student table *and noplace else*; you would use a query
joining the Student table to the Class table to see the name in conjunction
with class information.

What are your Tables, with relevant fieldnames?
What is each table's Primary Key?
How are the tables related?
--

John W. Vinson [MVP]