Simple budget tracking db

[Guest]

I need to make a simple databases that will add up total days worked, amount
paid, and account balance. I don't want to keep picking the person's title
and account he's working under---I want the populate the form so all I need
to do is type the days and hours. Each person could have 2 titles and work
under 5 different accounts. Tables below:

EMPLOYEE
empSSn
empName
etc...

ACCT
Acct#
AcctName
FiscalYear
StartingBalance

TITLE
TitleID
TitleName
TitlePayRate

PAYROLL
ParyollID
Ssn
Acct#
TitleID
HoursWkd
DaysWkd

Thanks...

 

[Ed Robichaud]

I assume you have defined relationships so that your tblPayroll is linked to
tblAcct, tblEmpolyee, etc.

Since each employee can have multiple accts and/or titles, you will need to
enter those three items for each
time and billing record. You could use combo-boxes (for each of the three)
to speed-up/limit data entry.
-Ed