Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


tripp

3561 posts

Uber Geek

Trusted
Lifetime subscriber

#197974 20-Jun-2016 15:59
Send private message

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

 

 


Create new topic

gzt

gzt
11677 posts

Uber Geek

Lifetime subscriber

  #1577249 20-Jun-2016 16:30
Send private message

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

tripp

3561 posts

Uber Geek

Trusted
Lifetime subscriber

  #1577250 20-Jun-2016 16:33
Send private message

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

 

 

 

 

 

 


 
 
 
 


freitasm
BDFL - Memuneh
68866 posts

Uber Geek

Administrator
Trusted
Geekzone
Lifetime subscriber

  #1577352 20-Jun-2016 18:55
Send private message

What database is being used?

 

Edit: I see, you want something where you can enter the schema and it will do the cross-reference, without accessing the database directly...





 

 

These links are referral codes

 

Geekzone broadband switch | Eletcricity comparison and switch | Hatch investment (NZ$ 10 bonus if NZ$100 deposited within 30 days) | Sharesies | Mighty Ape | Backblaze | Coinbase | TheMarket | My technology disclosure


tripp

3561 posts

Uber Geek

Trusted
Lifetime subscriber

  #1577353 20-Jun-2016 18:57
Send private message

Oracle.
However for the program can use anything.

Create new topic





News »

Huawei launches IdeaHub Pro in New Zealand
Posted 27-Oct-2020 16:41


Southland-based IT specialist providing virtual services worldwide
Posted 27-Oct-2020 15:55


NASA discovers water on sunlit surface of Moon
Posted 27-Oct-2020 08:30


Huawei introduces new features to Petal Search, Maps and Docs
Posted 26-Oct-2020 18:05


Nokia selected by NASA to build first ever cellular network on the Moon
Posted 21-Oct-2020 08:34


Nanoleaf enhances lighting line with launch of Triangles and Mini Triangles
Posted 17-Oct-2020 20:18


Synology unveils DS16211+
Posted 17-Oct-2020 20:12


Ingram Micro introduces FootfallCam to New Zealand channel
Posted 17-Oct-2020 20:06


Dropbox adopts Virtual First working policy
Posted 17-Oct-2020 19:47


OPPO announces Reno4 Series 5G line-up in NZ
Posted 16-Oct-2020 08:52


Microsoft Highway to a Hundred expands to Asia Pacific
Posted 14-Oct-2020 09:34


Spark turns on 5G in Auckland
Posted 14-Oct-2020 09:29


AMD Launches AMD Ryzen 5000 Series Desktop Processors
Posted 9-Oct-2020 10:13


Teletrac Navman launches integrated multi-camera solution for transport and logistics industry
Posted 8-Oct-2020 10:57


Farmside hits 10,000 RBI customers
Posted 7-Oct-2020 15:32









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.