Sandroid wrote:
Access 2007. Problem is when I delete the device (which has foreign
key, ipID) from device table the IP number from IP
table (has ID, primary key) also deletes (relation 1:1). I want to
"free" ip number when I remove device from database so IP number is
not deleted and can be used later. How to accomplish this?

I must be forgetting how to read... or not awake yet. Do you have cascading
deletes turned on between the two tables? If so, turn it off.

--
Message posted via http://www.accessmonster.com