Hello all,
Long time no query!

I'm just finishing a multi-user solution and having set the privileges a problem has appeared which I can't figure out no matter what I try...

Basically, with full access, a script which controls record numbering on new records works fine; but as soon as you log in with a non- [full access] account the reset record number script (which is a step within a create new record/omit all others/go to layout script) does not work.

I've now amended the privilege set to allow everything, but the missing script-step persists...

The non-effective script runs like this...
Go to record – last
Set next serial value (record number; record number + 1)
//record number is an auto-entry serial number

Without full access, if the last record (after, say, a deletion or two) is numbered 2, a new record appears numbered 5.
With full access the number correctly appears as 3.

I am officially flummoxed!

Any ideas?

Tim

Just a thought, but iif this is a multifile solution, and you have a script set to "run with full access", it only runs with full access in the file in which the script is created. Other files acted on by the script maintain their actual login status. Just a hunch.

If that isn't the problem, I'd look at the field validation on your serial number field.

I have this distinct feeling that I've been here before!
Convinced that I've found the Holy Grail FMP bug...
Only to discover the depths of my own stupidity!
Thanks John; your words nudged me to do something I hadn't - and surprise, surprise, it worked!
Now I can't believe I lost a day fretting over this!