G
Guest
I have a database with a field named "Job #." Job # must be unique, so I
have the index set as Yes (no duplicates).
The problem I am running into is that data is entered through a form, and if
someone completes data entry and there is already a job with the Job #, they
receive an error message about a duplicate value. If they go back and change
the Job # to something we know does not exist, they still get the error.
I understand that we can do a Before Update on the field and provide them
with a user-friendly message.
My question is if there is an easy way to know what the next available job
number is, without forcing the user to open the table every time.
Another concern is that this database is used by multiple users throughout
the day and as one user commits data, it is not appearing in the open table
on another users computer. The users have expressed a desire to not have to
close the table all the time. They want to minimize it during the day, and
restore as needed. Is there an easy way to refresh the table view, or query
view without forcing the end-user to re-run the query?
Thanks in advance.
have the index set as Yes (no duplicates).
The problem I am running into is that data is entered through a form, and if
someone completes data entry and there is already a job with the Job #, they
receive an error message about a duplicate value. If they go back and change
the Job # to something we know does not exist, they still get the error.
I understand that we can do a Before Update on the field and provide them
with a user-friendly message.
My question is if there is an easy way to know what the next available job
number is, without forcing the user to open the table every time.
Another concern is that this database is used by multiple users throughout
the day and as one user commits data, it is not appearing in the open table
on another users computer. The users have expressed a desire to not have to
close the table all the time. They want to minimize it during the day, and
restore as needed. Is there an easy way to refresh the table view, or query
view without forcing the end-user to re-run the query?
Thanks in advance.