Solved

Orphaned Table Occurrence on Relationship Diagram

Posted on 2008-10-29
3
639 Views
Last Modified: 2010-05-18
I have a FileMaker 8.5 database with 16 tables and a crazy relationship diagram. Some tables have multiple table occurrences on the diagram, and I am almost certain that over the development process, some of these table occurrences are no longer necessary. How can I find out if a table occurrence is an orphan that can be removed, short of reviewing every layout, every script, etc.? Thanks!
0
Comment
Question by:cafoster
3 Comments
 
LVL 3

Accepted Solution

by:
D0N earned 400 total points
ID: 22837729
The "Advanced" version of Filemaker Pro can give you a detailed database report.  If you've got a solution with that many tables and that many relationship complexities, it'd be well worth the investment.
0
 
LVL 28

Assisted Solution

by:lesouef
lesouef earned 100 total points
ID: 22838589
true. it will tell you the usage of every table occurence, which script, layout is using it.
you can also duplicate the file for safety, then delete table occurences; fm will issue a msg if the occurence is used.
0
 

Author Closing Comment

by:cafoster
ID: 31511455
Thanks! I had Filemaker Developer 7 and remembered having those tools, but I so rarely use Filemaker that I was hoping there'd be another way of doing it on the cheap :-) I'll see if my boss is willing to spring for the upgrade. Thanks again!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question