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
<*> 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/
