2 Replies Latest reply on Jul 3, 2012 2:50 PM by Stephen Huston

    The action cannot be performed the required table is missing.

    aarjunmuthu

      Hi,


      While commit my records. It is showing the action cannot be performed the required table is missing.


      Once i press ok. It is updating data in that table. How to resolve it. i m using two files one for interface and another one for data.


      Used external data source to acess data file into interface. some layouts are working fine.


      Kindly anyone to help me to resolve.


      Thanks in advance.

        • 1. Re: The action cannot be performed the required table is missing.
          taylorsharpe

          How about a little more information.  What version of FileMaker?  Is it on Server?  Is the table a native FileMaker table or ESS?  If ESS, where is it from?  Is the write ability off for the entire file or just that table?  If it is the entire file, the file permissions may not have write access on the OS level.  Have you tried it on another computer?  Have you tested it on an account with [Full Access]?  If not, it may be a FileMaker permissions issue. 

          • 2. Re: The action cannot be performed the required table is missing.
            Stephen Huston

            When using multiple files or a data separation model, you need to very careful not to delete a TO (table occurance) which is the base table for some layout or scripted action in a file.

             

            It sounds like you have a layout or script action which relies on a TO which is not longer in that file. If you have an OnCommit trigger script, check it as the most ikely place for a script step which needs repointing to the new/correct TO. If not that, go into layout mode and use the Manage Layouts menu (top of the layout list) to see if any of the layouts are missing a base table.

             

            There are other possiblities, but all of them are likely to have to do with a missing TO (table occurance in the relationship graph).