We have a business solution that has been growing form nearly 5 years. It has been through many developer hands including my own stubby fingers that are high on ambition but short on great coding skills. The solution does everything we need it to and looks good as well but underneath I believe it may be a bit disheveled for the long haul as our company grows and we seek to add new features and capabilities. I would like to get rid of old layouts, old fields, unused scripts to start just to start the clean up. Then move onto streamlining our naming conventions and layouts, before handing it over to a proper filemaker developer who could look undertake hood and make suggestions for its long term stability. Are there any tools to use to help with this clean up or do I simply have to go table by table, field by field and layout by layout trying to determine what is actually in everyday use with live data versus what might have been started and abandoned, in favor for more elegant code.
As always, thank you in advance for your help.