Avatar

Level 2

I Have This Customer Information Form That's Sort of an Ordering Forms , I Made It By LiveCycle v9.0

And I Want To be able to search for Specific Record and Modify it and Save It Again to The DataBase

I believe That We All Saw The (( Data Connected Forms Presentation )) For Pual Guerette

At One Part Of The Presentation (Minute 0:26:00 specifically) When He Try To Search A Specific Record In the Database

And He Got all this annoying Messages Then The Record what He looking Shows up ; He Said That We No Longer able to Modify The Record After We Doing the Search

My First Question Is Why ???

Is there anyway After I got that Specific Record I Want from the Database I Can make my modification on it and update it Back in the DB.

OR i Have to Browse the whole DB looking for it Specially that I got this (ID Auto Increasment Number field Issue) Which leads me to ;

My Second Qustion;

Why I Can't just connect ''The Form Order Number'' to an Auto Increasment Number field in the DB

Obviously i can't, So Can I do Anything to achieve this goal ??


I Believe that we can Find some scripting to make that Happen 

I Will Be So Grateful If There Is Any Helpful Answer

FYI: I'm Not Java Expert So If There Is any Coding That's Can be Helpful Please POST ALL OF IT if you can ,,,,