Need advice on software

Forums › IT Pro and developers › Need advice on software

tripp

3848 posts

Uber Geek

Trusted

Lifetime subscriber

#197974 20-Jun-2016 15:59

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 :)

gzt

17111 posts

Uber Geek

Lifetime subscriber

#1577249 20-Jun-2016 16:30

It is an access database and you are developing in access or something different?

tripp

3848 posts

Uber Geek

Trusted

Lifetime subscriber

#1577250 20-Jun-2016 16:33

gzt: It is an access database and you are developing in access or something different?

No i don't want to develop it at all, just want a program that is already made, if needed I can make it in access but I am super lazy :P

So just asking if anyone already knows of software that does this, I select a value from a field it then tells me where the field is and what else uses the field.

I can enter everything in manually, I just need a system if I update something I know i have to go and update other things before I have someone ring me and say it's all broken.

So lets say I have a bakery

I enter in "Flour", it tells me it's from "Supplier 1" and "supplier 4" it then tells me I use it to make "Muffins" and "brownies"

So if i change "flour" to something else then I can no longer make "muffins" or "brownies" unless I update those :P