2 Replies Latest reply on May 29, 2009 10:43 AM by jsutherlin

    can 2 FM Server Adv share data via IWP

    jsutherlin

      Title

      can 2 FM Server Adv share data via IWP

      Your post

      I have 2 locations each with their own FM Pro Server Adv. The servers share data between each other without any issues but there is now a need to have that shared data show up in IWP sessions. To test this I created a relationship between a database on each of the servers, created a layout to show the related data and published it out to the web via IWP. The related data shows up fine when viewing the data in FM Pro but I only see blank fields where the related data should be in the IWP session. I can't find anything in the documentation that says this is not supported. Anyone have any ideas on this. I'm running FM Pro Server Advanced 10 on Windows 2003 Standard Server at both locations. Thanks.

        • 1. Re: can 2 FM Server Adv share data via IWP
          TSGal

          jsutherlin:

           

          Thank you for your post.

           

          I am unable to duplicate the problem, so let me tell you what I did to try and reproduce the problem.

           

          1. I launched FileMaker Pro 10 and created a database file, File1.fp7, with two fields:

          ID (Text)

          Name (Text)

           

          2. I entered the following two records into the file:

          ID: 1

          Name: TSGal

           

          ID: 2

          Name: jsutherlin

           

          3. I went to another machine, launched FileMaker Pro 10, and created a second database file, File2.fp7, with two fields:

          ID (Text)

          Stuff (Text)

           

          4. I created a relationship between File2.fp7 and File1.fp7 based upon ID field in both files.

           

          5. While on the second machine, I went into Layout mode and created a portal into File1.fp7 displaying the Name.

           

          6. I went into Browse Mode, entered ID: 1, and TSGal displays in the portal.

           

          7. I turned on Instant Web Publishing with access set to All Users for File2.fp7.

           

          8. I returned to the original computer and turned on Instant Web Publishing with access set to All Users for File1.fp7.

           

          9. I went to a third machine, launched a Browser and entered the IP address of the second machine.  I selected File2.fp7, added a new record, entered ID: 2 and clicked Submit.  jsutherlin appears in the portal.

           

          I do not have two servers to test out, but it should act identically.

           

          Let me know what else I should try on my end.

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: can 2 FM Server Adv share data via IWP
            jsutherlin
               I created a test database for each server, setup relationships and enabled IWP. Through Filemaker the cross server relationships work fine but through IWP they still don't. Could this be an issue with Server Advanced even though you got it to work through IWP within Filemaker?