Personnel, Salary and account distribution

[Wendy]

I am fairly new to Access and I was looking for a template to help me track
employee's wages and their distribution among many account. One faculty
member could have 3 types and compensation, each charged to 4 accounts, for a
total of 12 accounts... Does anyone can help me get started? I am currently
using an excel sheet which I had linked to Access to create reports.
However, would like to just create an Access database that includes all
personel information, compensation and compensation types, and accounts.
Thanks

 

[Steve]

TblEmployee
EmployeeID
FName
LName
etc

TblCompensationType
CompensationTypeID
CompensationType

TblAccount
AccountID
CompensationTypeID
AccountDesc
AccountNumber

TblEmpWage
EmpWageID
EmployeeID
WageDate

TblEmpWageAccount
EmpWageAccountID
EmpWageID
WageAmountToAccount
AccountID

Create a form/subform. Base the main form on TblEmpWage and the subform on
TblEmpWageAccount. Thie way you can bring up an employee in the main form,
enter the date in the main form and enter his wages into various accounts in
the subform.

Steve
(e-mail address removed)