Hi Lutz

The solution worked brilliantly. Many thanks.

Could you please explain the RelationshipTable.MASTERID>RelationshipTable.RELATEDID and the RelationshipTable.MASTERID<RelationshipTable.RELATEDID

once again, many thanks

Hi Lutz

Thank you for that response. The code worked. Here is my problem. My relationship comes from another table where the relationship is defined as a fromdirection and a todirection.

RelationShipName...

Hi Lutz

Thanks for your reply.

Changing the table design is out of my hands and would require an act of congress.

I have tried your solution. This wont work if you use...

Here is the code for the sample data

create table RelationshipTable

(

RelationshipTableID int not null identity,

MasterID int null,

RelatedID int null,

Relationship varchar(30) null

)

insert into RelationshipTable (MasterID,RelatedID,Relationship) values (200,201,'Parent')

insert into RelationshipTable (MasterID,RelatedID,Relationship) values...