My form works good if the order has one job, but if it has two jobs then itdisplays only second one I use livecycle 8 to design the form and acrobat to run the form

Database table(sql server)

SureI have one table with order data and other with job related data....likemaster and detailWhen user enters order number then I want to display all its jobinformation.For ex: order number 1111 can have two jobs 0001 and 0002Please let me know if still not clearthanks

Hello,I have an order form and for every jorder i need to display job informationUser enters Order number and based  this order number, i need to disply Job information. An order can have more than one jobAny help would be appriciatedThanksMSPatil

Hi,I used SQL SERVER provider to connect to DAtabase but i get following error"Connection for Source DataConnection failed because the environment is not trusted"Any feedback on this is appriciatedThanks

Hi Paul,How do we handle errors I Formcalc script?If the query do not return any value then need to display some alert ordisplay all fields as null.

Error message: "ado2xfa operation failed. Item cannot be found in thecollection corresponding to the requested name or ordinal." But when I check the Database record I see it is updated

Hello Paul,The Link was very helpful but I still couldn’t figure out how to update DBon click event of button

Hi Paul,Am trying to update database column using below script but it errorsoDC.#command.query.select.nodes.item(0).value = ("update employee set cnt=",cnt.rawValue," where employee_id =",employee_id.rawValue,"") Same like the select query. I searched on forum too but didn’t find anyAny help is appr...

Please ignore my previos post...was able to fix itthanks