creating a table

[Guest]

Can you please help me!

I need to create a table(x) that is based on information from another
table(Y). If the information in Y is updated/changed the information in X is
automaitaclly updated/changed.

Y will have employee information and X will have training information that
the employees completed.

This is in MS Access

Thank you

 

[Rick B]

You would not store inforamtion from Table x in Table y, so making changes
in table X would be irrelavent. The only thing you'd store in both tables
would be the employee number...



TblEmployee
EmployeeNumber
EmplLastName
EmpFirstName
EmpStartDate
EmpTermDate
EmpDepartment
EmpAddress1
EmpAddress2
EmpCity
etc.


TblTraining
EmployeeNumber (from the other table)
ClassNumber
ClassDate
ClassGrade
etc.


TblClasses
ClassNumber
ClassName
etc.



MS Access is a "relational" database whoch means that the data should be
stored in separate "related" tables. You never store redndent data in more
than one table. In the above information, each employee would have one
record in the employee table. For every class they attend, they would have
one related record in the Training table. The training table uses data from
the Classes table.