Carl, have a quick question. Instead of having BusinessId_BusinessMember and BusinessId_BusinessGroup in the BusinessGroupMember table, couldn't I just have BusinessId in BusinessGroupMember table and use that column as part of...

Brillant!! In providing the answer to my problem, you also answered my general question of what a circular reference really is. Thanks you very much. I really appreciate it.