On 11 touko, 15:00, "PieterLinden via AccessMonster.com" u49887@uwe
wrote:
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 viahttp://www.accessmonster.com

cascading turned off - no help
referential integrity turned off - no help

which way to create the relation from IP to Device or vice versa, does
it matter?