If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
Add new tables to database
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 |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mutliple Tables lookup? | Westley | Database Design | 4 | June 15th, 2004 01:07 AM |
Linking Tables in External Database - Programatically | Karen B | Database Design | 1 | June 9th, 2004 12:41 AM |
How do I design a database based on the information that will be stored? - Copy of Tables and hirearchies.zip (0/1) | Jim | Database Design | 1 | June 1st, 2004 01:44 PM |
Separate database for tables? | Holly Clifton | Database Design | 3 | May 18th, 2004 06:20 PM |
Trying to create Database / Piviot tables | alexzagrant | Worksheet Functions | 0 | November 26th, 2003 06:08 PM |