By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,263 Members | 2,640 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,263 IT Pros & Developers. It's quick & easy.

Copy Data from Subform in A97

P: n/a
I have a quote system in A97 that uses a form and subform. The form
is linked to QuoteMaster table and the subform to QuoteDetail table.
The subform has all of the details that make up the actual quote
(other than the header info). The form and subform are linked by the
QuoteNo, which is AutoNumber in the QuoteMaster table.

I want to be able to start a new quote and then copy all of the
subform detail (except the QuoteNo) from a previous quote so that the
detail is identical to the earlier quote. Ex: Like I would start a
new quote (number 200) complete the header info and then issue an
instruction to copy the detail, from say, quote no 18.

What is the best way to do this?

Thanks,

Brooks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sun, 01 May 2005 22:09:40 GMT, bc******@midsouthcolor.com (Brooks
Clayton) wrote:

An append query. It would likely take two parameters: the QuoteNo to
copy from and the QuoteNo to copy to.
After running the query, you may have to requery the subform to see
the new records.

-Tom.

I have a quote system in A97 that uses a form and subform. The form
is linked to QuoteMaster table and the subform to QuoteDetail table.
The subform has all of the details that make up the actual quote
(other than the header info). The form and subform are linked by the
QuoteNo, which is AutoNumber in the QuoteMaster table.

I want to be able to start a new quote and then copy all of the
subform detail (except the QuoteNo) from a previous quote so that the
detail is identical to the earlier quote. Ex: Like I would start a
new quote (number 200) complete the header info and then issue an
instruction to copy the detail, from say, quote no 18.

What is the best way to do this?

Thanks,

Brooks


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.