Theodore- Same technique - just change the target table name. As soon as you "dirty" a field in a new tblOrders row, you can fetch the generated AutoNumber value to use in rows you insert into tblOrderDetails.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of tyki9799 > Sent: Saturday, June 18, 2005 11:20 PM > To: [email protected] > Subject: [ms_access] Re: Moving records between tables > > > I think I kind of confused you here. Sorry...! I don't want to write a > new Offer and move the records of an old one to the new one. I just > want to amend an existing Offer (stored in tables tblOffers and > tblOfferDetails) to an Order. That is, to tranfer the records from > tblOffers to tblOrders and the related records in tblOfferDetails to > table tblOrderDetails. > > The scenario is to open the particular Offer in form frmOffers and > then by pressing a command button make this happen. So in end, this > particular Offer's records will be moved to tables tblOrders and > tblOrderDetails and removed from tables tblOffers and tblOfferDetails. > So in the end the particular Offer will be considered as an Order and > not as an Offer anymore. > > I hope I made myself clear now. > > Theodore > > > > > > Yahoo! Groups Links > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
