You use a query to sort and the EmployeeID to identify the employee. A join
on EmployeeID from the employees table will display a name.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
"SSi308" wrote in message
...
How does the table know who the record is for when running reports?
For example the ContractsAndHours subform was created from the
ContractsAndHours table. If I do a query on the ContractsAndHours table
information and there is no name field how do I sort by employee name?
Thanks for the reply it is very much appreciated.
"Arvin Meyer [MVP]" wrote:
You don't ever need to store the name in 2 places. The only data that
should
ever be duplicated is the key.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
"SSi308" wrote in message
...
I have a form called ContractsIn which has a subform called
ContractsInAndHours.
The main part of the form consists of:
Employees.ID
Employees.Name
The subform has the fields:
ContractsAndHours.ID
ContractsAndHours.Name
ContractsAndHours.DailyHoursWorked
ContractsAndHours.ContractOut
This form is used by the supervisor to enter the hours worked and the
contracts in for each day.
When entering hours and contracts for each employee I would like the
Name
field in the subform automatically filled in with the name in the main
form
when entering through the field.
Can this be accomplished?
.