• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 672
  • Last Modified:

Orphaned Table Occurrence on Relationship Diagram

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
cafoster
Asked:
cafoster
2 Solutions
 
D0NCommented:
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
 
lesouefCommented:
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
 
cafosterAuthor Commented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now