to many fields for 1 table

  • Thread starter Thread starter Lainie
  • Start date Start date
L

Lainie

How can I add many date fields to a table for a form. I
need 180 date fields yet it will only let me enter 150
fields. I don't know how to get around this. They each
need to be their own field on the form since the form is
on employees and each date is for the date trained on
individual equipment etc. Thanks for any help you can
give me.
 
How can I add many date fields to a table for a form.
Click to expand...

By properly normalizing your tables, you will need ONE date field in
your table.
I need 180 date fields yet it will only let me enter 150
fields. I don't know how to get around this. They each
need to be their own field on the form since the form is
on employees and each date is for the date trained on
individual equipment etc. Thanks for any help you can
give me.
Click to expand...

The proper design for this does not include 180 *fields* - a one to
many relationship embedded in a single table - but 180 *RECORDS*.
Consider using the table structure:

Employees
EmployeeID
<bio information>

TrainingAreas
TrainingID
<type of equipment or training description>

TrainingDates
EmployeeID <<< link to Employees
TrainingID <<< link to TrainingAreas
TrainingDate

Your Form could be based on the Employees table, with a Subform based
on TrainingDates; this subform would have two fields, one for the
training type using a Combo Box, and the other a textbox in which to
enter the date.
 
Back
Top