I have a bookings database with a booking ref auto enter serial,how do i script so i can find a previous record,say booking ref 003 then copy the field entries to the newxt new record say 010,for example mr jones who booked a week ago has rung again and wants to book,i search under his name and find his record which was b.ref 003,the next booking ref will be 010 and i want to copy all his details into that new b.ref???

Temporarily put the info into global fields.