Hi,<BR><BR>I am connecting to SQL Server 7 database (using SQL Server 2000 enterprise manager).<BR><BR>When I create a relationship between tables I cannot see the boxes that say &#039;Cascade Related Update fields/Delete Fields&#039;. Why would this happen ? Because I cannot cascade, I get the following errors when updating a field using ASP:<BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE statement conflicted with COLUMN REFERENCE constraint &#039;FK_rolesandresponsibilities_roleslookup&#039 ;. The conflict occurred in database &#039;aspire&#039;, table &#039;rolesandresponsibilities&#039;, column &#039;Role&#039;. <BR><BR>How can I enforce cascade ? When I look at other databases I can see the boxes, just not when connecting to this one. Please help!<BR><BR>Thanks,<BR><BR>Hal