C
Connie
I have a unique index on a field which is populated on my form by a rule that
uses the max function + 1, but because multiple users may use the input form
simultaneously, they can encounter the message that the form cannot be
submitted because the changes would create duplicate values in the index,
etc. (This will only happen if a second users begins a new record before the
first user selects Submit.)
Is there a way to capture this error when the user selects Submit and to use
the error as an event which can re-run the max +1 function to calculate the
new value for the field? Alternately, can I capture the error and give the
user my own error message so that the user does not have to select Show
Details and interpret the message?
uses the max function + 1, but because multiple users may use the input form
simultaneously, they can encounter the message that the form cannot be
submitted because the changes would create duplicate values in the index,
etc. (This will only happen if a second users begins a new record before the
first user selects Submit.)
Is there a way to capture this error when the user selects Submit and to use
the error as an event which can re-run the max +1 function to calculate the
new value for the field? Alternately, can I capture the error and give the
user my own error message so that the user does not have to select Show
Details and interpret the message?