Add new tables to database

Linda,

I knew that :-) No, it doesn't make any difference, in fact that's the
whole point... your proposed table structure allows for this, as it
reflects the real-life relationships between the real-life data
elements. The data in the Assignments table will look something like this:

AssignmentID EmployeeID WorkArea AssDate Hours
1 1 CV 28/6/04 12
2 2 ER 28/6/04 8
3 1 ER 29/6/04 8
4 2 NICU 29/6/04 6
5 2 CV 29/6/04 6
6 1 NICU 30/6/04 12
7 2 NICU 30/6/04 12
.... so you see, it allows for any given Work Area to have more than one
Employee working there on any given day, and it allows for any given
Employee to work in more than one Work Area, including on any given day.
As I understand your requirements, this model should be ideal for your
purposes. And you will be able to easily use queries to obtain
summaries, per Employee, or per Work Area, or per date.

--
Steve Schapel, Microsoft Access MVP


LMB wrote:
There can be 2 or more employees assigned to 1 work area. Does that make
any difference?

Thanks,
Linda

Faith...I need to have faith...Thanks


"Steve Schapel" wrote in message
...
Linda,

I knew that :-) No, it doesn't make any difference, in fact that's the
whole point... your proposed table structure allows for this, as it
reflects the real-life relationships between the real-life data
elements. The data in the Assignments table will look something like
this:

AssignmentID EmployeeID WorkArea AssDate Hours
1 1 CV 28/6/04 12
2 2 ER 28/6/04 8
3 1 ER 29/6/04 8
4 2 NICU 29/6/04 6
5 2 CV 29/6/04 6
6 1 NICU 30/6/04 12
7 2 NICU 30/6/04 12
... so you see, it allows for any given Work Area to have more than one
Employee working there on any given day, and it allows for any given
Employee to work in more than one Work Area, including on any given day.
As I understand your requirements, this model should be ideal for your
purposes. And you will be able to easily use queries to obtain
summaries, per Employee, or per Work Area, or per date.

--
Steve Schapel, Microsoft Access MVP


LMB wrote:
There can be 2 or more employees assigned to 1 work area. Does that
make
any difference?

Thanks,
Linda