Finding Unused Fields

[bob sherman]

I have separated an old flat file into several relational files but am left with numerous fields that are no longer needed. Is there a quick way of determining which fields are no longer used in a layout so that I can delete them? Thanks.

[AudioFreak]

If you go into find mode and insert an = and perform the find if the field is empty it will find all the records that are empty in that field. If you don't have a lot of fields this should allow you to find the empty fields. HTH

[bob sherman]

True, but there are no records in this file to check against but there are over 600 fields to check out. Some more obvious than others. Thanks.

[adityaverma]

If you are using FM Pro developer then you can generate a report of the database and then you can easily find unused fields as it shouws the linkages.

HTH,

Aditya

[Vaughan]

Go into the Access Privileges, Overview command (in the File Menu). Click on a field name on the right column and it will display all the layouts that contain this field.

[AudioFreak]

Yeah........I suppose no records and over 600 fields would make that a little tedious. I do like Vaughn's suggestion.

[bob sherman]

Going to Access Privileges did the trick. Thanks for your help.