Hey all...

I have a field that is auto enter, serial. I need to make sure that-that
number is NEVER deleted. When I delete a record, it IS deleted.
So, it seems, I must, somehow, make the record non deletable. Right? But
how?

Thanks

In article <2eqti.538$LM1.42 [at] newsfe02.lga>, "Latka Gravis"
<itsmewhoelse [at] fastmail.fm> wrote:

> Hey all...
>
> I have a field that is auto enter, serial. I need to make sure that-that
> number is NEVER deleted. When I delete a record, it IS deleted.
> So, it seems, I must, somehow, make the record non deletable. Right? But
> how?
>
> Thanks

The only way to stop record deletion is to set-up an Access Privileges
Password that doesn't allow deletions ... remembering to have a
password that still allows you FULL access so you can do things like
delete test records.

You might also have to look at tunring off access to Editing records,
otherwise users can simply delete all the field data in a record. That
would leave the Serial Number (assuming you protect the fild), but the
record's data would still be gone.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Latka:
One way to do this is to set up a separate database that only assigns
serial numbers. Maybe a name and a field that auto-assigns a unique
serial number.
Then just link that field to the record you want serialized.
That way, when you delete a record, the registration database still
holds the data.

In article <2eqti.538$LM1.42 [at] newsfe02.lga>, Latka Gravis
<itsmewhoelse [at] fastmail.fm> wrote:

> Hey all...
>
> I have a field that is auto enter, serial. I need to make sure that-that
> number is NEVER deleted. When I delete a record, it IS deleted.
> So, it seems, I must, somehow, make the record non deletable. Right? But
> how?
>
> Thanks
>
>

"Latka Gravis" <itsmewhoelse [at] fastmail.fm> schreef in bericht
news:2eqti.538$LM1.42 [at] newsfe02.lga...
> Hey all...
>
> I have a field that is auto enter, serial. I need to make sure that-that
> number is NEVER deleted. When I delete a record, it IS deleted.
> So, it seems, I must, somehow, make the record non deletable. Right? But
> how?
>
> Thanks
>

If you use a true serial it will not be reused again when you just delete a
record.
If you want to re-use a number you can create a looping script that creates
the serial, even fills any gaps.
I have used this combined to a user menu, where I replaced the default
action CTRL-N (creates a new record) with the firing of this script.


Keep well, Ursus