2 Replies Latest reply on Aug 11, 2012 1:34 PM by Stephen Huston

    separation model w fmgo 11

    martinc

      We have hosted files on fmsa11 currently and use Citrix/RDP/Local access. This works pretty well. Our main file is very large and is very slow via fmgo.

       

      I've created a hosted file to be used in a Separation fashion. I've added a few tables and a few fields. This seems to work well. The relationships don't seem to carry over to the newly separated file. example: can't add a portal on Accounts to show related Jobs. In the original file, these two tables are related.

       

      Can I add relationships on the separated tables and not mess up the original tables?

        • 1. Re: separation model w fmgo 11
          BenGraham

          Hi Martin,

           

          In your new Interface file you want to put the relationships to the Data file (the original file).  Yes so the interface file, that you will later put on your mobile device, is where you add the table occurances that are to the data file.  It will not effect the relationships in the data file.  Although in the data file a minimal amount of TO's are needed. Most of the working TO's are in the interface file.

          • 2. Re: separation model w fmgo 11
            Stephen Huston

            I second Ben's point: your baisc relationships need to be defined in the interface file's relationship graph using TOs based on the tables in the data file. Minimize the relationships in the data-storage file,  leaving the basic TO for each table in the data file on the graph, even if not related in any way. Let the interface file carry the relationship load as much as possible.

             

            This will also minimize the need to fiddle with the data-storage file's graph down the road, allowing you to update the interface file independently -- the real benefit of the Separation Model.