Alexander Willey
Registered User.
- Local time
- Today, 02:21
- Joined
- Mar 1, 2013
- Messages
- 31
Dear Forum
I am creating a simple timesheet database (see attached form layout)
And wanted help to get the table design right.
i was thinking this would require 3 tables
AdvisorName
Week
TimeSheet
I was thinking that AdvisorName would link to Week with 1-M and that week would have a compound key. And that Week would link to Timesheet with 1-M which in turn would have 3 keys (AdvisorID, WeekID, TimeSheetID) so a compound key of 3.
1) is this arrangement sensible?
2) How do you suggest the Week data is handled. Should I do it with a date field or a number field
Appreciate any help on this
Many thanks
Alex
I am creating a simple timesheet database (see attached form layout)
And wanted help to get the table design right.
i was thinking this would require 3 tables
AdvisorName
Week
TimeSheet
I was thinking that AdvisorName would link to Week with 1-M and that week would have a compound key. And that Week would link to Timesheet with 1-M which in turn would have 3 keys (AdvisorID, WeekID, TimeSheetID) so a compound key of 3.
1) is this arrangement sensible?
2) How do you suggest the Week data is handled. Should I do it with a date field or a number field
Appreciate any help on this
Many thanks
Alex