Northwind Customer Table

[Wayne]

How could I best show relationships between the customers
in the Northwind database? Let's say Island Trading owns
Bon app' and Eastern Connection and also manages Que
Delícia.

Thanks!

 

[John Nurick]

Hi Wayne,

Something like this:

tblRelationships
RelationshipID - autonumber primary key
Relationship - text
Inverse - text
e.g.
1," owns "," is owned by "
2," manages "," is managed by "

tblCustomerRelationships
FirstID - foreign key into CustomerID
SecondID - foreign key into CustomerID
RelationshipID
(all three fields in primary key)

So the fact that Island Trading owns Bon app' (and that Bon app' is
owned by Island Trading) is stored in the record
ISLAT, BONAP, 1

 

[Wayne]

Thank you very much John. I like your solution.

Wayne

-----Original Message-----
Hi Wayne,

Something like this:

tblRelationships
RelationshipID - autonumber primary key
Relationship - text
Inverse - text
e.g.
1," owns "," is owned by "
2," manages "," is managed by "

tblCustomerRelationships
FirstID - foreign key into CustomerID
SecondID - foreign key into CustomerID
RelationshipID
(all three fields in primary key)

So the fact that Island Trading owns Bon app' (and that Bon app' is
owned by Island Trading) is stored in the record
ISLAT, BONAP, 1

How could I best show relationships between the customers
in the Northwind database? Let's say Island Trading owns
Bon app' and Eastern Connection and also manages Que
Delícia.

Thanks!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.