So?  The point is that *somewhere* you have keys referencing the branches table for that value.  That&#39;s why you can&#39;t delete it.  The data could be in *any* table w/ a branches foreign key.  <br><br>--joe<br><br><div class="gmail_quote">
On Thu, Dec 3, 2009 at 12:02 PM, Zico <span dir="ltr">&lt;<a href="mailto:mailzico@gmail.com">mailzico@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br><div class="gmail_quote"><div class="im">On Thu, Dec 3, 2009 at 9:30 PM, Joe Atzberger <span dir="ltr">&lt;<a href="mailto:ohiocore@gmail.com" target="_blank">ohiocore@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">


You can&#39;t delete a branch that has any items or users (and possibly other data) associated with it.  Edit or delete those first.<br></blockquote></div><div><br>Actually, i don`t have any patrons there in this system. Patron is null there.<br>


<br></div></div><br>-- <br>Best,<br><font color="#888888">Zico<br>
</font></blockquote></div><br>