Protect a row from being deleted

[Rob]

Is it possible to prevent a row from being deleted in a table. I want
to arrange a new table with an autonumbered primary key that will form
part of a set of sequential serial numbers. I want to protect the
integrity of the sequence so that an accidental deletion of a row can
not occur.

With thanks
Rob

[Keith Wilby]

Re: Protect a row from being deleted

"Rob" <dy@woodyallan. bizwrote in message
news:MHZDk.1590 $sc2.1194@news-server.bigpond. net.au...

Is it possible to prevent a row from being deleted in a table. I want to
arrange a new table with an autonumbered primary key that will form part
of a set of sequential serial numbers. I want to protect the integrity of
the sequence so that an accidental deletion of a row can not occur.
>
With thanks
Rob

Set the "allow deletions" property of the form to "no" and provide a field
to flag records as deleted then filter accordingly. Also, don't rely on
AutoNumber for sequential numbers, provide your own using the DMax function.

Keith.

https://www.keithwilby.com