D
dab1477
I would like to import specific fields from a SINGLE recordset in an
Engineering database to a separate Marketing Database as an appended
recordset to my main table. The idea here is that Engineering has quoted a
product. Once that product is quoted and accepted, then Marketing needs to
use SOME of the information in order to create and track the new part. If I
can import a single recordset's fields, then I would not have to manually
input all the Engr. data into the Marketing recordset.
I wanted to do this via a macro where I insert a Primary Key of the Engr.
Recordset into the macro. The macro pulls out the Engr. recordset and appends
to my Marketing table. I am unable to get started. Any help is appreciated.
I realize it would be best to have a single DB, but this is what I
inherited. Thanks for the assist to this intermediate neophite user!
Engineering database to a separate Marketing Database as an appended
recordset to my main table. The idea here is that Engineering has quoted a
product. Once that product is quoted and accepted, then Marketing needs to
use SOME of the information in order to create and track the new part. If I
can import a single recordset's fields, then I would not have to manually
input all the Engr. data into the Marketing recordset.
I wanted to do this via a macro where I insert a Primary Key of the Engr.
Recordset into the macro. The macro pulls out the Engr. recordset and appends
to my Marketing table. I am unable to get started. Any help is appreciated.
I realize it would be best to have a single DB, but this is what I
inherited. Thanks for the assist to this intermediate neophite user!