copying rows

M

MinTy

HELP!

I have two forms form1 and form2 (which is a subform). I have created
a combo box (on form2) that is populated with a value from a table. I
need a button that will look at the value in the combo box, execute a
Statement that will search another database and insert a bunch of rows
based on the entry in the combo box.

The combo box holds a "group" identifier which is also present in the
rows I want to copy. There is a 1-many relationship between them.

Basically this is for an order system where I want to insert standard
set of parts for a single product.

Any help would be appreciated.

Regards

Minesh Patel
Senior SA.
 
Top