I can select a record from a source data table by building a Recordset, then use the "Insert Record" wizard to insert selected fields into another destination table. But it only works one recordata time. How can I insert new records in the destination table for ALL of the records which satisfy the criteria in the recordset?
Need a simple cart / product management solution that can do some basic things. Been looking for over 2 years and can't find one that will work for me. Flat rate shipping, multiple tax rates, keep the same server, notification of order to multiple email addresses. Simple stuff, really. But I'm just a simple Web site designer...not a code junky. I leave that part to brainy people like you. I'm sure if you came up with such a cart, it would be a mondo hit.