AnsweredAssumed Answered

How to clean deleted fields from DDR listing and from import order listing (FMPro14Advanced)

Question asked by Peter.Guthrie on Sep 21, 2016
Latest reply on Sep 22, 2016 by justinc

I have a database that has developed through several different users (none of us are professional programmers) over about 10 years.

There are a large number of fields that have been added and deleted over the years. When I run the DDR, Several of the Scripts have more than have of the field lists as <Missing Field>. It gets distracting. It is also a problem when I am setting up a defined import order, because all of those missing fields show up as blanks on the FM column.


Is there any way to clean up the data base to remove all of those empty field "memories"? I realize one solution would be to reconstruct the database, but I don't really have that much time (or energy). Does FM have any tools to help with this?


Thanks, pbg