Hello,
I have an order form and for every jorder i need to display job information
User enters Order number and based this order number, i need to disply Job information. An order can have more than one job
Any help would be appriciated
Thanks
MSPatil
Views
Replies
Total Likes
Can you explain a bit more? Where does the data live? Are you making a print solution or is this an interactive system? Are you expecting to work on one order at a time or are all orders displayed?
Paul
Views
Replies
Total Likes
Sure
I have one table with order data and other with job related data....like
master and detail
When user enters order number then I want to display all its job
information.
For ex: order number 1111 can have two jobs 0001 and 0002
Please let me know if still not clear
thanks
Views
Replies
Total Likes
Where is the data coming from ...an XML file?
Paul
Views
Replies
Total Likes
Database table(sql server)
Views
Replies
Total Likes
Ok now I understand. You can certainly connect the form to a database an execute SQl commands to get the data out but that means that each machine that will access the DB has to have a dataconnection on it (only available for windows machines). If you are intending on using Reader as the client then the form must be extended using LiveCycle Reader Extensions. If you are using Acrobat then Reader Extensions is not required.
Do you still want to proceed?
Paul
Views
Replies
Total Likes
My form works good if the order has one job, but if it has two jobs then it
displays only second one
I use livecycle 8 to design the form and acrobat to run the form
Views
Replies
Total Likes
OK ....
You will have to execute SQL commands to get the appropriate records. You will have to write script to make this happen. There is a good blog on this technique at this link:
http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/
There are other good database related articles up there that you may want to check out.
Paul
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies