2 Replies Latest reply on Dec 12, 2009 9:49 PM by RickWhitelaw

    Change data source for all occurrences of a table

    typeleven

      Title

      Change data source for all occurrences of a table

      Post

      <!-- [if gte mso 9]><xml> <w:WordDocument>   <w:View>Normal</w:View>   <w:Zoom>0</w:Zoom>   <w:PunctuationKerning/>   <w:ValidateAgainstSchemas/>   <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>   <w:IgnoreMixedContent>false</w:IgnoreMixedContent>   <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>   <w:Compatibility>    <w:BreakWrappedTables/>    <w:SnapToGridInCell/>    <w:WrapTextWithPunct/>    <w:UseAsianBreakRules/>    <w:DontGrowAutofit/>   </w:Compatibility>   <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif] --><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif] --><!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:"";      margin:0in;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:"Times New Roman";      mso-fareast-font-family:"Times New Roman";} @page Section1      {size:8.5in 11.0in;      margin:1.0in 1.25in 1.0in 1.25in;      mso-header-margin:.5in;      mso-footer-margin:.5in;      mso-paper-source:0;} div.Section1      {page:Section1;} --><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable      {mso-style-name:"Table Normal";      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:"";      mso-padding-alt:0in 5.4pt 0in 5.4pt;      mso-para-margin:0in;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:10.0pt;      font-family:"Times New Roman";      mso-ansi-language:#0400;      mso-fareast-language:#0400;      mso-bidi-language:#0400;} </style> <![endif] --><!-- [if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026"/> </xml><![endif] --><!-- [if gte mso 9]><xml> <o:shapelayout v:ext="edit">   <o:idmap v:ext="edit" data="1"/> </o:shapelayout></xml><![endif] -->

      I want to split my current filemaker database into two files. One will be the interface file and the other will be the data file. I know that I can go to the relationships window and double click on a table occurrence and select the new table from an external source. But is there a way to tell file maker to tell all the other table occurrences that are using that same table to now use that external data source?

        • 1. Re: Change data source for all occurrences of a table
          FentonJones
             No. The Relationship Graph does not support that. You have to change each one. It is however pretty good at keeping the relationships fields lined up (since they are really the same fields as before). It does not take that long to create such an Interface file. 
          • 2. Re: Change data source for all occurrences of a table
            RickWhitelaw
              

            Before you start to split your solution, go to the Relationships Graph, select a TO and then click "Select Tables with the same source table" from the button at the bottom of the screen. This will at least highlight all the occurrences of a given table and make things a bit easier. There are pros and cons to both the single file and multiple file approach. The subject is worth some research before making a decision. You've probably done that . . .

             

            RW