5 Replies Latest reply on Apr 6, 2010 2:45 PM by sly_1

    external datasource

    sly_1

      Title

      external datasource

      Post

      hello again,

       

      Im having problems getting this to work,

       

      I have 10 external datasource.

      1

      2

      3

      4

      5

      6

      7

      8

      9

      10

       I have created a value list to include the name of 1 2 3 4 so on.

       

      what i want to do is when i click on the drop down menu is to pick a name (10) and it will bring me to that external datasource that i picked.

       

      what im asking is how to create a script to do this.

      the script that i create i would like to use as a script trigger OnObjectModify.

      Is this posible

       

       

      Any help would be greatly appreciated

       

       

      Thanks

       

      Sly

        • 1. Re: external datasource
          mrvodka

          You need to supply more information. I am unclear on what you are asking for. Please try to be more explicit. Abstract examples do not help.

          • 2. Re: external datasource
            JoshO.

            Are you talking about going to a layout that shows you the records from the specified Data Source?

             

            You would need 10 different layouts...pass a script parameter to the script and use If...Else If to tell FileMaker what layout actually want to go to.

            • 3. Re: external datasource
              sly_1

              ok i have 11 data sources.

               

              tracker 1

              tracker 2

              tracker 3

              tracker 4

              tracker 5

              tracker 6

              tracker 7

              tracker 8

              tracker 9

              Communications

              Document library

               

               

              I have a main datasource call ( business portal)

               

               

              on business portal i have a drop down list of all external data source file names

               

               

              what i would like to do is say i click the drop down and select tracker 2

              i would like to automaticly open tracker 2 with teh current user/pass and so on for the rest of the data sources

               

               

              ive done this for navigating layouts witthin a datasource

              i just dont know how to do this for external datasource

               

              thank you i hope this is a little clearer\

               

              fm10 advanced

               

               

               

              • 4. Re: external datasource
                mrvodka

                Hold on. When you mean external data source do you mean another filemaker file or do you mean an ESS source?

                 

                 

                I am gonna guess and assume you mean file. You can use an onObjectModify script trigger to call a script that takes your selected field value and then depending on it open the file tha tyou want with a series of If/ElseIf.

                 

                If [ gSelectSource = "tracker1" ]

                Open File [ Tracker1 ]

                ElseIf [ gSelectSource = "tracker2" ]

                Open File [ Tracker2 ]

                 

                ...

                 

                End If

                • 5. Re: external datasource
                  sly_1

                  its another Filemaker file

                   

                  hope tyhis helps