Setting up a database and i need to duplicate the record a certain number of times depending on the result entered on the orginal record entered... is this possible?

You can set a global number field based off your initial record's field data. you will need another global field to be used as a counter.

Then do a loop to duplicate the records

Exit the loop when gEnd = gKounter

I can't think of too many reason why you would need to duplicate a record several time, except maybe for Mailing Labels. Why not tell us what you are wanting to accomplish (i.e. why do you need to duplicate the records), and maybe we can suggest a better way to get the results you want.

Lee

I have a hotel reservation system when the orginal reservation comes in I need to make a record for each person for the number of rooms and number of people per room....for example if i have a reservation for 2 rooms 4 people per room I need 8 records to be made

Take a look at this post:

Click Here

HTH

Lee