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.

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

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.

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

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.

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

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