7 Replies Latest reply on Jun 9, 2009 8:31 AM by pguerett

    Loop

    MsPatil

      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

        • 1. Re: Loop
          pguerett Level 6

          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

          • 2. Re: Loop
            MsPatil Level 1

            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

            • 3. Re: Loop
              pguerett Level 6

              Where is the data coming from ...an XML file?

               

              Paul

              • 4. Re: Loop
                MsPatil Level 1

                Database table(sql server)

                • 5. Re: Loop
                  pguerett Level 6

                  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

                  • 6. Re: Loop
                    MsPatil Level 1

                    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

                    • 7. Re: Loop
                      pguerett Level 6

                      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