creating a temp form based on field variable, then insert all records in the temp form into another form
i keep getting an error, is my syntax incorrect?
rec = SR_Import[Imported != "Yes"];
{
for each row in rec
{insert into PS_Work_Order_Purchase_Order
[
Company_Name = rec.Company
PS_Work_Order_Purchase_Order = rec.WO_Number
Description = rec.WO_Description
AFE = rec.AFE
Site_Code_Location = rec.Location_Full
Field_Ticket_Signer = rec.Field_Ticket
//= rec.PS_Contact
Attention_to_on_Invoice = rec.Invoice_Submit_To
WO_Date = rec.Reported_Date
]
}
}