Hi to all!
I have two sets of two tables. The first set is made of tables
tblOrders and tblOrderDetails (almost as in Northwind sample
database). The second set of made of tables tblOffers and
tblOfferDetails. The 'Details' tables carry the items ordered and
offered.
I'd like to add an Offer record to tblOrders when the offer is
accepted and so it is turned into an order. So far so good, as I could
do that with an INSERT query in VBA. The problem arises when I want to
add the corresponding items that where first offered and now ordered
and originally been kept in table tblOfferDetails. How Access will
know what is the number (in this case an autonumber) of this new Order
in tblOrders so that the new Order will correlate to the right ordered
items and insert them in table tblOrders?
So in other words, I'd like to move a record from tblOffers to
tblOffers and the corresponding records in tblOfferDetails to
tblOffersDetails. The problem is that I cannot make the program know
the value of the primary key (it's an autonumber) of the new record in
tblOrders so to move the corresponding records from tblOfferDetails to
tblOffersDetails.
Thanks in advance,
tyki9799
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/
