rainman89
I cant find the any key..
- Local time
- Yesterday, 20:16
- Joined
- Feb 12, 2007
- Messages
- 3,015
Hi all,
I am trying to create a db for a timesheet program. i am running into issues on how to create the correct tables with the correct values.
i have 3 tables
Case
caseID (pk)
caseName
caseNumber
client
Task
taskID(pk)
task
Employee
employeeID(pk)
userName
userPass
employeeLast
employeeFirst
and one taht ties them together. This is where i get confused
timesheet
startTime
endTime
totalTime
notes
date (pk)
expenses
mileage
originally had employeeID, caseID and task ID in this but i wasnt sure that was right. so i removed them and added
employeeLast
employeeFirst
caseName
caseNumber
client
task
and linked them to the appropriate tables using the relationships....
I feel very strongly that this is the wrong design structure but am at a loss as to how else to design this..
i basically want the user to login using a login form i figured out from using this site... capturing the username to populate the employeeLast and First and then allowing the user to add as many client and tasks that they need to for that particular day.
thinking this would be done using a form and subform with employees and a timesheet subform..... is that the right track.? any help would be appreciated.
I am trying to create a db for a timesheet program. i am running into issues on how to create the correct tables with the correct values.
i have 3 tables
Case
caseID (pk)
caseName
caseNumber
client
Task
taskID(pk)
task
Employee
employeeID(pk)
userName
userPass
employeeLast
employeeFirst
and one taht ties them together. This is where i get confused
timesheet
startTime
endTime
totalTime
notes
date (pk)
expenses
mileage
originally had employeeID, caseID and task ID in this but i wasnt sure that was right. so i removed them and added
employeeLast
employeeFirst
caseName
caseNumber
client
task
and linked them to the appropriate tables using the relationships....
I feel very strongly that this is the wrong design structure but am at a loss as to how else to design this..
i basically want the user to login using a login form i figured out from using this site... capturing the username to populate the employeeLast and First and then allowing the user to add as many client and tasks that they need to for that particular day.
thinking this would be done using a form and subform with employees and a timesheet subform..... is that the right track.? any help would be appreciated.
