Yes, get filemaker advanced. I've done exactly what you described using database design reports from filemaker advanced.
I open the report in a web browser and use the browsers find tool. If the field or table occurrence doesn't show up anywhere but where it's defined, I know I can delete it.
After you do that, check out the script debugger. That tool alone has saved me countless hours of hair pulling by enabling me to find where a script was messing up.