I have a table and a column Matter.Matter_Number. This is NOT an ID.
This Matter_Number is saved to mulitple tables. When I change Matter.Matter_Number I need to update the various tables where Matter_Number is saved.
Below is a sample.
Matter.Matter_Number = 5423.01
Client.Matter_Number = 5423.01
TBS.Matter_Number = 5423.01
HBM.Matter_Number = 5423.01
Now I want to change Matter_Number to 6423.01 but I can't remember all the tables that have Matter_Number.
How can I do a search to find what tables have Matter_Number?