Anyone?I have a feeling that I need to add somthing like this on the ddlist?if (Len(Ltrim(Rtrim(SelectField.rawValue))) > 0) then //Change the commandType from TABLE to TEXT. TEXT is the equivalent of SQL Property $sourceSet.DataConnection.#command.query.commandType = "text" //Set the Select Node. Select in this case will be whatever the SQL Property you want. $sourceSet.DataConnection.#command.query.select.nodes.item(0).value = Concat("Select * from Table1 Where ID = ", Ltrim(Rtrim(SelectField....

"Is there a way to only lock certain types of objects"If you wrap the objects you want to lock into a subform, and use the name of the subform in the call to the scriptobject, instead of form1.This will give you total control of which items are locked and which are not locked.It works well.

Thanks Niall, that helps a great deal. I now understand where I went wrong!

Paul posted an example of this, here:http://forums.adobe.com/thread/341252?start=150&tstart=0http://forums.adobe.com/servlet/JiveServlet/download/2689916-41209/Lock%20All%20Fields_Purchase%20Order.pdf

Sorry, I had not published it!https://acrobat.com/#d=LgnXPZacCClFizup1g0Q8A

Thanks, your example works great.However, I tried to do this myself without using a table, and am still having problems summing up the total cost value?Not sure what I am doing wrong?https://acrobat.com/#d=LgnXPZacCClFizup1g0Q8A

Thanks Niall, Just done a test, this works, but I seem to be having a problem calculating the total in form2?Is this because the data in form2 has been imported into the form? The usual formcalc or js does not appear to work?Tried both the below:Sum (CostField1, CostField2)Total.rawValue = CostField1.rawValue + CostField2.rawValue;Thanks