Clients make bookings for pets to be visited and walked and these bookings can range from one day upwards.

I have a form to enter all the booking information and I am trying to write a script to add each visit (up to three a day for a varying number of days) to another form in the database called Visits. This form will eventually be displayed as a calendar and form the basis of reports e-mailed to clients etc.

I have read many of the comments on the forum about the issues of For/While loops and I suspect that creating a self-calling function to add the records is the only way to go in my case because of the variable nature of the number of visits to be added.

Has anyone implemented a similar senario successfully and do they have any comments or suggestions for how to make the implementation trouble-free?

I would also welcome comments and thoughts on whether I am going about this in the right way.