Newbie questions please assist..

[imgame]

I am trying to set up a roster of whom attended what class and then it would
automatically place that class in each individuals record of training.. can
anyone assist me in how I would do just that.
I want to be able to enter the persons name the other info from the class in
one "sheet" per say then it would copy that class info ect to their personal
list of classes. I have the classes and the names set up, just can't figure
out how to create a roster to do what I am asking..
Thank you

 

[Jeff Boyce]

Consider another approach. With a relational database like Access, there's
no need to "copy ... info .. to" another table - that just duplicates data
already available.

Without more information about your specific situation, here's a couple
ideas:

tblPerson
PersonID
FName
LName
...
DOB

tblClass
ClassID
ClassTitle
ClassCategoryID (from a lookup table, ?tlkpClassCategory, used to
categorize classes)
...

trelClassParticipant
ClassParticipantID
ClassID (foreign key, from tblClass)
PersonID (foreign key, from tblPerson)
BeginDate
EndDate
FinalGrade
...

This is purely speculation ... I hope there's a useful idea or so in this.

Good luck

Jeff Boyce
<Access MVP>

 

[imgame]

Jeff thanks for the insight, more directly my problem is to create a form,
that will add to each students record each time it is filled out and keep a
running list of classes and dates ect..

 

[Jeff Boyce]

Until your data structure is cleaned up, you'll continue to have problems
getting that form to work.

With a more normalized structure, one approach would be to have the student
info (name, DOB, etc.) in a main form, and the "each record/class/..."
information in a subform. This sounds like a one-to-many (parent-children)
situation.

Good luck

Jeff Boyce
<Access MVP>