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 (http://office.microsoft.com/en-us/templates/TC102068801033.aspx?CategoryID=CT101428241033&WT.mc_id=42) 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.

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.

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: http://www.allenbrowne.com/casu-22....