Replicate records automatically

  • Thread starter Thread starter Piers
  • Start date Start date
P

Piers

Hi folks,

In a training database, have fields; date,
course_duration and course_ID (and others).

I want to be able to enter the info in e.g. 5 day course
starting 01/01/03, and for the (duration - 1) number of
records to be replicated, with the date incrementing but
the course_id and duration staying the same.

Unfortunately it won't always be a five day duration (Max
of 5 days)

Tried a few things but no joy.

Thanks in advance,

Piers
 
Don't replicate records. If all that there is different for each day is
the date, add a field called EndDate and record the date the training
ends in that field for the same record.

Pavel
 
Back
Top