I created an Action to Copy all values of one record into a New record. But I'm not sure how to go about copying all child records of that record. I could open up a SQL connection and copy them all that way, but is there a better way?

This is 7.5.3

Do it on the LAN? Run some kind of batch job on the LAN? (the new jobservice in 8.0 is perfect for this). I've done this in the past with Knowledge Sync....you basically write a clone record request to a table from the Web....a KS event monitor picks it up and fires off the Basic program script that copies the record(s). if it's hundreds or thousands of items involved in the cloning you don't want to do this through the web....

THis needs to be in an Action on a button that the user clicks when viewing a specific record (Opportunity Product). Actually I have this on a DataGrid...

<p>string opid = QFDataGrid.DataKeys[QFDataGrid.SelectedIndex].Values["Id"].ToString();
 

Sage.Entity.Interfaces.IOpportunityProduct opportunityproduct = Sage.Platform.EntityFactory.GetById<Sage.Entity.Interfaces.IOpportunityProduct>(opid);

Sage.Entity.Interfaces.IOpportunityProduct opcopy = Sage.Platform.EntityFactory.Create<Sage.Entity.Interfaces.IOpportunityProduct>();

 opcopy.Account = opportunityproduct.Account;

 opcopy.Opportunity = opportunityproduct.Opportunity;

 opcopy.Broker = opportunityproduct.Broker;

 opcopy.Received = opportunityproduct.Received;

 opcopy.Save();

The Opportunity Product was copied to a new one. However, that Opportunity Product has several "Opportunity Product Parts" child records that need to be copied as well to the new Opporunity Product. Any isea on how to do this in a Snippet Action Item without direct SQL connection?

You need to do a for each loop on the child parts

Here is a sample, of course I made up your entitny name so you will have to adjust 

foreach (Sage.Entity.Interfaces.IOpportunityProductParts pp in opportunityproduct.Parts)

        {

Sage.Entity.Interfaces.IOpportunityProductPart newpp = Sage.Platform.EntityFactory.Create<Sage.Entity.Interfaces.IOpportunityProductPart>();

newpp.OppProduct = pp.OppProduct;

newpp.Name = pp.name;

        }

Worked like a charm. Thanks Brian!