Solved

Hierarchical Data Structure Issue

Posted on 1998-03-11
11
198 Views
Last Modified: 2006-11-17
I'm wondering if there is a better way to set up my data structure.

The nature of the data is this:
I have a set of processes.
Within each process there are several sub-processes.
Each process and sub-process have a set of objectives associated with them.

The way it is currently set up is as follows:
Process Lookup table lists the process names
Subprocess Lookup table lists the subprocess names
Process Subprocess Relationship table has an ID, Process ID and Subprocess ID

This results in a list in which each process ID is repeated for each of its associated subprocesses plus a blank which I use to denote all subprocesses in the process.

Now I want to add objectives.  First I built the lookup table:

Objectives Lookup table lists the objectives

Then I saw two alternatives:
I could add an Objectives ID field to the Process Subprocess table - seems like the wrong thing because I'd be repeating the Process - Subprocess relationship multiple times for no reason.
or
I could create a Process Objectives table with Process Subprocess ID and Objectives ID - seems right because now I can attach all the objectives I want to each process subprocess pair with repeating the pairing.  Problem is it tells me the relationship is indeterminate when I do it.

Am I missing a far better way to do this or am I on the right track?  

Thanks in advance.
0
Comment
Question by:greilly
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 12

Accepted Solution

by:
Trygve earned 70 total points
ID: 1970587
It sounds to me like this could be done more easily; without the relationship table etc.
Can the sub processes be connected to more than one process ? If not you could include the processID as a field in your subproject table. The same is valid for the objectives table(s), you could probably also include the ID of the project/subproject it is linked to.

If you want you could send me a zipped version of your app, including the tables involved and I will look at it. email: kontry@statoil.no

Trygve
0
 

Author Comment

by:greilly
ID: 1970588
You should be able to find a zipper on any shareware site. Try:

http://www.slaughterhouse.com:80/zip.html

0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970589
Did you find the zipper ?
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 12

Expert Comment

by:Trygve
ID: 1970590
can you recommend one in particular?  I looked, downloaded one (I don't remember which) and struggled with how to use it.  I think I downloaded a shell which I'm not sure is actually a full program.  What do you use?
0
 

Author Comment

by:greilly
ID: 1970591
I usually use WinZip or Visual Zip. I also use pkZip which is a good old DOS program. I can send you this one on mail if you provide me with your mail address...
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970592
thanks it's greilly@measure.net
0
 

Author Comment

by:greilly
ID: 1970593
Did you get the file I sent you ?
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970594
the file is on the way to you.  let me know if you don't get it in one piece.
0
 

Author Comment

by:greilly
ID: 1970595
I got the file. I will have a look at it later today or tomorrow.
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970596
OK, it took more time than I had imagined to get back to you.

I have sent you a mail including some comments and a MDB with suggestions on how the tables could be set up.
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1970597
Got it.  That structure makes sense.  I'll email you at the end of the week regarding the other issues you brought up.  Thanks again.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question