free ip address in asset database, not remove them?

[Sandroid]

Win 7, access 2007 , tables: asset and ip, relation (asset.ipIP,
foreign)one-to-one(ip.ID, primary)

when I delete an asset from asset table using form it is also deleted
from IP table. This should work such as the IP address remains to be
used in other asset. How to resolve this? If I change the relation
there is no more validatation that one IP address is used once?

Other problem is that how I can make forms in "read only" mode without
creating copies of them and setting properties? that user cannot make
changes to table by accident.

Help me, Please!

-S

 

[Tom van Stiphout]

On Mon, 10 May 2010 06:45:54 -0700 (PDT), Sandroid

With a 1:1 relation it is important how you create the relationship.
You need to drag the field from the primary table to the foreign
table. What you are describing indicates you did it the other way.

To make a form readonly, set the AllowEdits property to False. I'm
glad you agree making copies is a bad idea

-Tom.
Microsoft Access MVP

 

[Sandroid]

Thanks Tom

Well I deleted the relation and drag from IP table (ID, primary key)
to Asset table (ipID, foreign key) but it still removes the related IP
row when I remove row from asset table. When I try to drag from Asset
table it gives me error (not originally in english) like "field name
in index or relation definition "id" is not valid"

About the forms. The read only behaviour shoud be default, but I want
to make changes also without leaving the form, so can I make i.e.
AllowEdit "toggle" button or is there a better way? How to create
toggle button to allow edits?

 

[Sandroid]

Thanks Tom

Well I deleted the relation and drag from IP table (ID, primary key)
to Asset table (ipID, foreign key) but it still removes the related IP
row when I remove row from asset table. When I try to drag from Asset
table it gives me error (not originally in english) like "field name
in index or relation definition "id" is not valid"

About the forms. The read only behaviour shoud be default, but I want
to make changes also without leaving the form, so can I make i.e.
AllowEdit "toggle" button or is there a better way? How to create
toggle button to allow edits?

toggle thing resolved.

IP thing need help!