Thank you for responding. I tried this, but I think my script is wrong:if (Court.rawValue == 1){ this.rawValue = 0;} else{ this.rawValue = (Fine+PassFine)*.7;}Any suggestions.Tracy

Merry Christmas everyone.I am creating a form in Designer that includes a calculation.  I need script to set the value of a particular field to zero and then exclude it from re-calculating when a particular selection is made in a drop-down list.  Setting the presence to "inactive" works great, excep...

I GOT IT! Paul, you are amazing!!! Every time I get to the end of my rope and finally ask for help, I figure it out before I get the answer. Maybe I should start asking sooner.My problem was in the second data connection. I was still linking the second data connection to a table. I changed this ...

You are correct. The actual SQL statement reads: oDataConn.nodes.item(1).query.select.nodes.item(0).value = "SELECT * FROM CourtDate WHERE Ctrm_ID = " + this.rawValue;

Yes (many times) I also found a pdf example called "populating a drop down list from database" which was very helpful. In an attempt to simplify (and learn the concept) I have tried setting up just two dropdown lists, with the second one being populated based on the selection in the first DDL. I a...

Thank you! Everyone working on this form has the standard version of Acrobat, so extending the form is not an issue. I have watched your video on connecting to a database several times, and it is what finally helped me accomplish this. But every attempt I make at these dynamic drop downs fails mi...

Hello and thank you for looking at my problem.I am trying to create dynamic or cascading drop down lists in Livecycle Designer ES2 v.9.  I need a total of three drop down lists.  The third DDL would provide three or four possible dates depending on the selections made in DDL1 and DDL2.  The list ite...

Hello and thank you for looking at my problem.I am trying to create dynamic or cascading drop down lists in Livecycle Designer ES2 v.9.  I need a total of three drop down lists.  The third DDL would provide three or four possible dates depending on the selections made in DDL1 and DDL2.  The list ite...

Greetings:  I have a developed a form connected to an Access database that scrolls through the records.  The print button executes several commands to clean up the form by eliminating information that is not used.  In order to the get the form back to the original condition and clear the existing re...

Form users are working in Reader x (ten).  I was getting a different error message when they were using the older version of reader, so I had them update.  Now, when they hit the submit button, users are getting a message that all mandatory fields have not been filled out.  The user should not get t...