Create a new record in another database with information from current record.

I have been dealing with this problem for about a week and I bet the solutions is simple!  I am not a Filemaker guru!  I working with two of the 17 databases that we have (Project Items.FP5 and Shipping Log.FP5).  I want to create a new record in the Shipping Log.fp5 database from the current record in Projects Items.fp5.  We have this function already in one of the other databases (Quote Items.fp5).  So I copied that script over to Project Items.fp5.  this is what I have for my script:

Set Field [ SHIPPING LOG::gChooseOffice, "CVCSTK" ]
Set Field [ SHIPPING LOG::Shipped To, Projects::Office ]
Set Field [ SHIPPING LOG::keyshippedfrom, "CVCSTK" & " x " & Status( CurrentDate) ]
Set Field [ SHIPPING LOG::Qty, Qty. ]
Set Field [ SHIPPING LOG::Item Number, Job Code ]
Set Field [ SHIPPING LOG::Description of item, Job Description ]
Set Field [ SHIPPING LOG::date, Status( CurrentDate) ]
Set Field [ SHIPPING LOG::jobnumber, Job # ]
Set Field [ SHIPPING LOG::Tracking #, "" ]
Set Field [ SHIPPING LOG::Received, "" ]

Now, the script works on some of the records but on other it creates a blank record in the Shipping Log.fp5 database.  Also if I have a record in Project Items.fp5 with multiple "Job #" but they are different records it overwrites the information in the Shipping Log.fp5 database.  It will only show the last entry it will not create mulitple records.  Now, like I said this function works fine in the other database all records get created correctly in the Shipping Log.FP5.  I am clueless as to why it does not work.  My relationship is in the Projects Items.fp5 is mirrored to the Quote Items.fp5 database.  Any help or input would be greatly appreciatedStart Free Trial