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?

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" <(E-Mail Removed)> wrote in message
news:8397B7AC-C8C5-4B9F-A57C-(E-Mail Removed)...
>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?
>

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" <(E-Mail Removed)> wrote in message
> news:8397B7AC-C8C5-4B9F-A57C-(E-Mail Removed)...
> >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?
> >
>
>
> .
>

On Tue, 18 May 2010 07:19:01 -0700, SSi308 <(E-Mail Removed)>
wrote:

>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?

Join the Employees table in the query: pull the contract and hour information
from the ContractsAndHours table, and the name from the Employee table. That's
what relational databases DO - let you combine data from multiple related
tables into one result.

If you're assuming that the Report must be based on a single table containing
all the needed information, you're missing the real power of databases!

--

John W. Vinson [MVP]

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" <(E-Mail Removed)> wrote in message
news:71EA33BC-6735-4070-992F-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:8397B7AC-C8C5-4B9F-A57C-(E-Mail Removed)...
>> >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?
>> >
>>
>>
>> .
>>