My case : I got an invoice form, invheader,invdetail ,invnumber (3
tables).

I want to lock the 'Invnumber' table , Get the newest number , then update
that tables, There are over 20 users to use this forms.

so What syntax / alog. should I write ??

Thanks in advnace.
From Agnes