Re: Lookup table lock

Hi,

Thank you both, Steven & Casey.

I'll look at Stevens method as in fact there are ongoing edits all day of
price and yes/nos as the stock changes. I could see clashes.

Regards
Anne


"Steven Green" <greens@xxxxxxxxxxxxx> wrote in
news:45d36b6d$1@xxxxxxxxxxxxxxxxxxxxxxxx:

On my system, when one operator is searching for a record on the
lookup, then a user on another machine is unable to calculate a total
of their Bookitems.

you should be doing that calc by scanning the restricted records that
apply, not by using the "calc" functions.. because of the locks the
"calc" functions place..

--
Steven Green - Waldorf Maryland USA


Hello, all.

When a user invokes a ctl-spacebar lookup does this place a table
lock? Yes, I know it does.

simply put

Student --->> Purchase --->> Bookitems(which looks up from books.db)

On my system, when one operator is searching for a record on the
lookup, then a user on another machine is unable to calculate a total
of their Bookitems.

--
-----
Anne Wainwright
Please reply to group
.