So long story short
I need software that if i select a database field it will tell me the source table/view etc its from and any dependency if I change the field, i.e. other views, reports etc.
It does not need to read/connect to the database, all info can be entered/imported in manually.
So if i pick "customerID" it will tell me that it is from "customer table" and also "sales table" and dependency on "sales report by customer" + anything else.
I would just make it in MS access but if there is something already out there then I won't have to touch access :)