Re: Table design question.

On 29 Jan 2003, jackie_ol_at_hotmail.com wrote:

> Comp1ID field means the company with ID 100200 is the parent and
> company with the ID 102011 is the child (or customer of Company A).
>
> I can add as many as hierarchical info like this.

This doesn't seem like a hierarchy as explained. You just seem to be capturing a customer relationship. The fact that a parent might also be a child to some other parent seems incidental, at least as described.

> Is this approach correct? Is there any other way to achieve this?

What questions will you need to ask? If all you need to know is customers of a particular company, this should work. What if you need to know companies that have customers that also have customers that also have customers ... and the lowest level customer is also a customer of the original company in question, ie, a web of company/customer relationships (some call it incest :-)). Can you define the questions you will need to answer?

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.