Hi Michael,

Thanks for all your help, after reading that I'll go ahead and use the sql you have suggested in your earlier post.

Best regards,

Al.

Hi Michael,

Great stuff, thanks for that.

Just one final question if that's ok? I entertained the trigger method earlier so that the stored procedure would not have to be modified...

Hi Michael,

An example of the sql I would use is....

--Computers

SELECT dei.EquipItemID, dei.EquipTypeID, dei.EquipFolderID, dei.IconID, dei.ImageID, dei.IsDeleted

FROM dbo.Dat_EquipItems dei

INNER JOIN dbo.Ref_EquipTypes ret

ON dei.EquipTypeID = ret.EquipTypeID

AND ret.Name = 'Computer'

LEFT JOIN dbo.Dat_EquipComputer deqc

ON...