>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.
With aDBObjects() function you can get array of all table names, then you would need to use each table and check using FIELD() function, for example.
Alternative way would be to use DBC as a table and do a query against it for the field name.
If it's not broken, fix it until it is.
My Blog