I think I'm almost there...except for...
In my current design I do have a main form with two subforms and it is what I
want.
"mnature" wrote:
tbl_Employees
EmployeeID (PK)
EmployeeInfo
EmployeeStatusInfo
EmployeeRateInfo
tbl_Payroll
PayrollID (PK)
EmployeeID (FK)
SubDepartmentID (FK)
WeekNumber
PayrollAmount
PayrollMultiplier
tbl_Departments
DepartmentID (PK)
DepartmentInfo
tbl_SubDepartments
SubDepartmentID (PK)
DepartmentID (FK)
SubDepartmentInfo
Once you set up these tables, make a query. Use the query wizard, and
choose your payroll table. Choose all of the fields. Now choose your
employee table, and choose all fields except for EmployeeID. Now choose your
subdepartment table, and choose all of the fields except for SubDepartmentID.
Finally, choose your department table, and choose everything except for
DepartmentID. Finish building the query.
Now make a form based on that query. Use the form wizard, and choose the
query you just created. At some point it will give you several options of
how to present your information. Choose "by Departments" and it will give
you a main form, and two subforms. Complete the wizard and view the results.
This will probably not be the way you want your information to look, but
illustrates how you can take the data from tables and present them.
|