multiple data entries on a single form

C

cjharsh

I have a single form that has data for a single event and within this event
there are several employees conducting this event that I would like to track
the employees activities. What is the simpliest way to go about putting what
I would describe as a data entry table into a form?
 
K

KARL DEWEY

Use a form/subform with two tables set up with a one-to-many relationalship
(Event-to-employee).
 
J

John W. Vinson

I have a single form that has data for a single event and within this event
there are several employees conducting this event that I would like to track
the employees activities. What is the simpliest way to go about putting what
I would describe as a data entry table into a form?
Click to expand...

You aren't putting data into a Form. Forms don't store data - they just
display it!

And if you have a "data entry table", you're on the wrong track. Just as Forms
aren't used for storing data, so Tables aren't used for entering data!

I *think* what you need is three tables: Events, Employees, and
EmployeeActivity (with fields for the EventID, the EmployeeID, and perhaps
other fields to record the nature of the employee's participation in the
event). You would use a continous Form based on Events with a subform based on
EmployeeActivity; this subform could have a combo box to select the employee.


John W. Vinson [MVP]
 
Top