redundant data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that I enter staff training in. I bring up the staff name then I put in the date and type of training and the instructor. I need the date,training and instructor to stay until I have entered all the staff that took the training. I dont want to keep entering the same data. I know there is hope out there.
Thanks
Jenny
 
You have to turn your solution on its head. First enter
the date, type of training and the instructor, then add the
staff who attended.

The first three items should reside on 1 table with a
unique identifier (e.g. trainingId) and the attendees
should reside on another table with the trainingId as a
foreign key.

There should be separate forms for each e.g. TrainingFrom
and AttendeeForm and the AttendeeForm should be a subForm
of the TrainingForm. The link between the forms is the
trainingId.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
I have a form that I enter staff training in. I bring up
Click to expand...
the staff name then I put in the date and type of training
and the instructor. I need the date,training and
instructor to stay until I have entered all the staff that
took the training. I dont want to keep entering the same
data. I know there is hope out there.
 
Try said:
-----Original Message-----
I have a form that I enter staff training in. I bring up
Click to expand...
the staff name then I put in the date and type of training
and the instructor. I need the date,training and
instructor to stay until I have entered all the staff that
took the training. I dont want to keep entering the same
data. I know there is hope out there.
 
Back
Top