multiple data entries on a single form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cjharsh - 30 Jul 2007 22:18 GMT

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?

Reply to this Message

KARL DEWEY - 30 Jul 2007 23:02 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> 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?

Reply to this Message

John W. Vinson - 31 Jul 2007 00:06 GMT

>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?

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]

Reply to this Message