1 of 1 people found this helpful
Filemaker Advanced's Database Design Report would seem like a good place to start here. There are also third party tools available.
Take a look at the Base Elements V2 trial (FM8, 9, 10) or V3 public beta (FM11)
They will pretty much tell you what is redundant, locate any errors and simplify the entire task, of course they do require that you produce a DDR report with FMP Advanced.
Also bear in mind that if any FM11 features are in use, or the DDR is created in FM11 then theres only a Time Limited Beta version available at the moment...
Whilst it is not a budget package by any means, the hours / days it has saved me was well worth it.
IIRC you can perform a full analysis and use all features in the trial for a limited time.
Any advice if I don't have access to a copy of FMP Advanced?
Yes, Buy a copy.
Seriously, the extra cost is easily justified by the time and aggravation saved--especially when you have to analyze a database designed by someone else.