Record locking issue

[StPeter]

Hi,

When user1 is working on tableA, user2 is prevented from making changes to (a different record!) in that tableA.

It is as if the full table is locked, instead of only the active record. This should not be (pretty basic i would say), but i can nevertheless not pinpoint the issue.

- Can it be related to the physical setup? (i'm using a dedicated machine to host the dbase with FMPro 11, shared over FM-Network to service up to 4 users (no server-version!))

- Or is it the data-structure? (small dbase, occurred when working on a portal (based on tableA) in a layout (based on tableB))

- Or ...?

Any help appreciated,

rgds,

[bcooney]

Are you receiving a record-lock FM error dialog?

See this thread:

Understanding Record Lock

[StPeter]

Are you receiving a record-lock FM error dialog?

See this thread:

Understanding Record Lock

That describes it 100%!

Perfect, thank you bcooney (i did a search on the keywords 'record' and 'locking' but didn't get this result, strange).

The proposed solution (=giving each user his own 'display record') would be to have more than 1 record (actually 1 for every user) in the base-table of the layout (and abandon the global-fields), correct?

Thx a lot! Very appreciated!