Cannot Change a Column to Lookup Column because it is used in report or query
Hi
By mistake I removed a Lookup Column from one of the columns in my table and now I cannot add it back since I get an error message saying that the column in question is used in XYZ report.
How can I resolve this situation? No information changed in any of the tables, and the table in question is used in a lot of queries and reports, so it is not feasible to delete and then recreate all of them.
any help is appreciated.
regards
TJ