M
macroapa
Hi,
I have a FE/BE database with each user having their own copy of the
FE.
In the FE I have a form bound to a linked table to the BE.
The form is in the tabular view.
Now I have the record lock of the from set to 'Edited Record' so that
if one user is already editing a record, another user cannot edit it.
However, what i would prefer to do is just lock the fields that are
being edited of the record as opposed to the whole record.
Is this possible or do I need to restructure my table?
The table is a simple 'booking system' with each record being for a
user for each day and the fields being the username, date, and then 48
fields for each 30min timeslot in the day. IE:
Name Date 8am 8:30am 9am 9:30am
Steve 01/01/2000 avail busy meetng avail
Fred 01/01/2000 busy avail avail avail
Thanks for any pointers.
I have a FE/BE database with each user having their own copy of the
FE.
In the FE I have a form bound to a linked table to the BE.
The form is in the tabular view.
Now I have the record lock of the from set to 'Edited Record' so that
if one user is already editing a record, another user cannot edit it.
However, what i would prefer to do is just lock the fields that are
being edited of the record as opposed to the whole record.
Is this possible or do I need to restructure my table?
The table is a simple 'booking system' with each record being for a
user for each day and the fields being the username, date, and then 48
fields for each 30min timeslot in the day. IE:
Name Date 8am 8:30am 9am 9:30am
Steve 01/01/2000 avail busy meetng avail
Fred 01/01/2000 busy avail avail avail
Thanks for any pointers.