Entering the proper value into the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a form to enter data into a table. When I enter an employee name
on the form, the employee's ID appears in the table. I'd like the name to
appear. How can I do this?
 
Typically, you wouldn't. The whole point of a relational database is to
store the related KEYS in a related tables; not the actual data.

tblEmployees
EmployeeNumber
FirstName
LastName
HireDate
etc.

tblTraining or something
EmpNum
ClassNum
ClassDate

tblClasses
ClassNumber
ClassName
etc.
 
Which one is the PrimaryKey of the tblEmployee?

If EmpID is the PK, it is correct to store the EmpID in the "other" Table
since knowing the EmpID, you can always find the Employee name quickly.

That is the whole isea of relational database!
 
Back
Top