contacts table

[DTSFreak]

Hi,

I'm designing a database where i have some tables about contacts. What i would like to know is what the best design is for creating contacts.

I have a table relations where i store persons name and company names. Now to determine the relation where who is related to who, e.g. a company and their contacts or a family with their family members, i need some sort of a recursive table/query.

Can anyone help me with this or is what i want not the right way?

 

[johnherman]

try looking at this article for starters

http://www.stargeek.com/item/397.html

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright