 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / March 2006creating a table
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 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.  SignatureRick B > Can you please help me! > [quoted text clipped - 9 lines] > > Thank you |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.