Got it. Poor design. Anyway...
It's been a while since I've done this, but I *think* you can run the documenting wizard and produce a text file of all the fields. Key word here being *think*
>It's a business system called Made2Manage that was written as one of those canned programs for manufacturing plants. So it is like divine providence, I can't change that.
>
>The field in question is Customer Number. FCUSTNO.
>
>It is in sales order tables, invoice tables, Job order tables, on and on... Many instances.
>
>I want to confirm that I have located all instances of this field in all tables.
>
>I am attempting to synch customer numbers with another division so I will have to replace all instances with the appropriate new number.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer