4 Replies Latest reply on Sep 2, 2010 12:57 AM by MSpsi

    ACK ! How hard can this be!!!

    MSpsi

      Title

      ACK ! How hard can this be!!!

      Post

      I need to export only the current record AND all related records and only all related records.  (There is alot of them)

      Isn't there an easy way of doing this?  I have tried export and send record but it caps out.  I am thinking some kind of related external file or runtime solution might be possible if I can filter my whole database by the current record only.  Anyone know of an plug in/application or native means of doing this?

      Cheers

      MSpsi

      ddr availible

      MacBook 2.26 Intel Core 2 Duo

      OsX 10.6.4

      FM PRO ADVANCE 10v3

        • 1. Re: ACK ! How hard can this be!!!
          LaRetta_1

          Use script-step Go To Related Records [ your child table ] and base it only 'match current record only'

          This provides a list of your detail records (you haven't described what they mean).  Export these child records instead ... and when you do so, include fields from the parent table as needed.

          If you are export to Excel, for instance, you will have same parent and one detail child record per line (which is considered a record) because it is a flat file.  There are ways you script such a process where the children are grouped via variable or calculation but we would need more information to advise properly.  Specifically, what does the result export look like?  What will you be doing with the information?  What is the program which will inherit the resultant data?

          • 2. Re: ACK ! How hard can this be!!!
            philmodjunk

            And to export only the current record, make your current record the only record in your found set.

            • 3. Re: ACK ! How hard can this be!!!
              LaRetta_1

              The GTRR script step isolates to only the related records for the current record.  The request by MSpsi was to export the child records; the parent record will be exported line for line with each child.

              • 4. Re: ACK ! How hard can this be!!!
                MSpsi

                Bah my long response just disappeared!!!  Can I send a PDF of my TOG Table?