Linking Form to Table

[Guest]

Hi, if anyone could help me. I'm trying to create a form that I can update
data date-wise, store this entry to a growing table and be able to print the
same depending on the parameters (date) I enter.

For example, I would enter the regular time of 8 hours and overtime of 2
hours for Employee John. Then I would do the same for the employee Martha, so
and so forth. Then I would like generate a report to list all the employees
where I entered working hours to.

How do I start preparing for this kind of database? Thanks.

 

[Scottgem (MVP)]

Your first step is designing your tables. You will need, at the least,
an employees table, a time log table and a lookup table for time type
(regular, OT, etc.)

Your log table should look like this:

tblTimeLog
TimeLogID (Primary Key Autonumber
EmployeeID (FOreign key)
TimeTypeID (FK)
WorkDate
WorkTime

You can create a main form bound to the employees table (use the wizard)
and a subform bound to the Time log.

 

[strive4peace]

Hi Rick,

The first thing you need to do is set up data structures so that all the
information you plan to track has a place to go. This document will
help you:

Access Basics
http://allenbrowne.com/casu-22.html
This 30-page training tutorial will orient you toward the core concepts
of Microsoft Access


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*