Hi All,

I am also facing a Circular reference problem. But, not able to get any idea to fix it.

Scenario: I have 3 tables:

tblUser(ntUserID, vcUserName, vcPassword) - Keeps User Information

tblGroup( ntGroupID, ntGroupOwnerID, vcGroupName ) - Keeps Group Information

tblGroupUser( ntGroupUserID, ntGroupID, ntUserID ) - Keeps user who has been assigned into a group

Relationship:

tblUser - > tblGroup(ntGroupOwner) - > tblGroupUser(ntGroupID) <- tblUser(ntUserID)

So, here I am facing circular reference.

Any suggestion to avoid this