Hi Guys,
Wondering if its possible to use Append Query to Copy records from 2 tables to 1 table, if yes then is it advisable to do so in the situation explained below?
Main Form (Quote) - fields are QuoteID, QuoteNo, Quote Desc etc.
Subform (Item Details) - I have copied item details from another table using Append Query, and this is where I want to copy QuoteID as well from main form to enable searching item records through QuoteNo
I haven't linked my main form and subform as it was affecting my Append Query process due to some reason.
Any possible help would be greatly appreciated.