Creating hierarchy in same table, how?

B

Bob

Primary Key Field CompanyID autonumber, next field is long integer
ParentCompany, allow nulls. I want to create a relationship between
CompanyId as the PK field and the ParentCompany as the child field. This is
easy in SQL 2000 but I can't find a way to do it in Access 2003. How could I
do this?

Thanks for any help.

Bob
 
D

Douglas J. Steele

Add the table to the Relationship window twice, and connect the two copies.
 
Top