AGAIN

[Guest]

HI.....please remember I am a novice at this, but am attempting to learn as
much as I can!

Ok...I have created this system to monitor training classes that people
take...

I made a table for their demographics......a table for the training topics
and then a training matrix.....but for some reason the information is not
linking when i create a form.....it does in table view...but when I create
the form, its not linked.......any suggestions on how to get this information
to work in a form AND track it.....

thanks
Ran

 

[Guest]

Hi Ransom, Iam new at this too. I cannot get one thing,templates,etc.!! HELP
!!!

 

[Guest]

lol...well sorry you are having difficulties....hopefully those things have
been installed on your system. but they are under File and New and you
should be given the option to proceed.....

 

[John W. Vinson]

HI.....please remember I am a novice at this, but am attempting to learn as
much as I can!

Ok...I have created this system to monitor training classes that people
take...

I made a table for their demographics......a table for the training topics
and then a training matrix.....but for some reason the information is not
linking when i create a form.....it does in table view...but when I create
the form, its not linked.......any suggestions on how to get this information
to work in a form AND track it.....

thanks
Ran

Could you explain what you mean by "a training matrix"?

And what do you mean by "linking"?

The proper design for this (based on what you've posted) would be
three tables:

People
PersonID
LastName
FirstName
<other demographic info>

Topics
TopicID
TopicName
<other info about the training topic>

Enrollment
PersonID <who's taking the training>
TopicID <what they're taking>
<any info about THIS person in THIS class>

The Form would have a main form based on *either* People (if you want
to assign topics to each person) *or* on Topics (if you want to select
a topic and assign people to it), with a Subform based on Enrollment;
this subform would have a combo box to select the Topic or the Person
respectively. You might want both forms.


John W. Vinson [MVP]

 

[Guest]

I am not sure if my post was received…but here again is a structure of what I
created

Employee
ID Number (main key)
Title
Address
Phone number
Email

Training Elements
ID Number (main key)
Category (this defines the type of training – initial, update, quarterly-and
is a lookup from another table)
Sub Category (this is the actual topic that was taught-mandating, new
hire-this is also a look up)
Trainer (a look up)
Date
District (a look up)
Time frame ( a look up—cause each topic may be 30 minutes …and hour..etc…)

Training Matrix
Employee ID
Training ID
Date (not sure why I needed this twice…do I?)

Once I created the form, I made Employee table the main form, but am not
sure which table should be the subform so that once I input the information
it is linked (that’s what I meant by linking) to that employee….am I missing
something in regards to the relationships……I created one from the Employee
table to the Matrix and then one from the Training Elements to the Training
Matrix…..where have I gone wrong?