Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Determine safety of deleting table occurrence

Recommended Posts

  • Newbies

Hi Everybody,

First time, long time.  I inherited a FM solution that I'm trying to pick apart to understand.  One aspect is that table occurrences were named with default names (table name 1, table name 2, etc).   Another aspect is that some tables are related to multiple occurrences of the same table (table 1 has two relationships based on the same key to table 2, table 2's occurrences have default names, i.e. table 2_1, and table 2_2).

So here I come, trying to figure out what is going on.  My question is, how can I determine if it is safe to delete a table occurrence (such as table 2_1 in the above example)?  I seem to get the same error when I go to delete table 2_1 as I do when I try to delete table 2.  Since I didn't put this solution together and there are a lot of parts, I don't feel safe is deleting anything.

Thanks for any advice.

Link to post
Share on other sites

It's hard to say you first have to determine what dependencies scripts / layouts and other are using the table occurrence.

the easiest way to do so is to use the a Database Design Report then analyze it with something like FMPerception or Inspector you can determine if schema is safe to delete.


Link to post
Share on other sites

The Database Design Report (DDR) mentioned above is under the FileMaker Tools menu if you have enabled the advanced options in your preferences. This is in FM17 and newer. In older versions, FileMaker Advanced was a separate product. Please set your version and OS in your profile here so we can better answer your questions.

Once you have the DDR, as Ocean West says there are various tools you can use to work with it. My go-to is BaseElements.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.