Hi:

I've inherited a rather cumbersome database with one table, 1400 fields, and hundreds of layouts. I'm trying to eliminate unused fields. I'm familiar with the Functions: FieldNames and LayoutNames. Is there a way to get Filemaker to tell me every layout a particular field is used in?

Thanks

With the Developer version you can get a full report. It's now Called Advanced.

HTH

Michael

Hi:

Unfortunately, I do not have the Developer version. I just wondered if there was a way using Functions and/or Scripts to workaround this.

http://fmnexus.com/InspectorLite.html

This is a great free tool for what you're facing.

Thanks for the link David I was not aware of that software.

Michael

Hi:

Thanks for the suggestion. I went to the web site and also saw a freeware called "FindIt", but unfortunately both that and your suggestion require v8 and I only have FMP 7.

Time to upgrade to FMP 9.0 Advanced!

You're welcome. The software is pretty awesome.

You do need Advanced to create the DDR though. Sorry about that OP.

I don't think it would be too hard to script your own "pseudo-DDR". Start by having your script loop through the layouts and create a new record in a Layouts table, with the layout name. Then you can use the FieldNames function to get the fields of each layout.