General Idea but no practical knowledge

September 28, 2009 at 17:28:58
Specs: Windows XP, Custom
I've been looking for a Data-base that would let me keep track of jobs and account for man-hours. Couldn't find one. I found a MS Customer Service Template ( that will work for me if I can add man hour accounting. So I figured I would just make a table. With ID number, Job Description, Man Hours. and put it in a combo box in the create case form. I've been poking at it for Two days and Have concluded that I'm not sure what I'm doing. I tried creating some relationships but I just keeping gettings errors.
All I want to do is build a table that has hours set for each job description and be-able to select a Job description from a Combo box when I open a case and have that link the man hours for the job description to the employee and the case.
Am I way over my head here? I've started reading some e-books but I can't find how to do what I want to do.

See More: General Idea but no practical knowledge

Report •

November 7, 2009 at 02:41:36
are hours always same for given job desc
across case numbers and employee?
f/e: if jobdesc is "foreman night shift", hours always 8.
global for all cases.

if so, that eliminates one vector.
so then call this h.
enter employee#
select job desc.
[hours now assigned to "h"]
that sets hours. then need a table with employee vs case#
for payrates on different case no.s.
set emloyee id as vector one (row#), set all pay cases as vector two (col head), and each cell should be employees payrate for that case#. locate employee in rows, case# in colheads, then mult h times [row,col] cell. i apologize in advance for any misunderstanding, i am not database proficient, so no offense if foregoing is painfully obvious to you.
just trying to help. i have not worked with sql.

Report •

November 15, 2009 at 06:40:20
Here's a link to some video info and text that might help put your situation into context, and assist you with finding a solution:

Report •

Related Solutions

Ask Question