N
Nick M via AccessMonster.com
I am setting up a database that is tracking problems with equipment. Each
error will have a unique "Error Number" that will be used to track the
status of the equipment. I currently am assigning this number using auto
number. I am starting to think this may not be the best way as I will have
multiple users contributing data.
The biggest problem is that the users will only be updating the database
from their computers every few days and do not have the ability to access
the main database for each record entry. My solution to this may be to
simply start each person's error number at very different starting numbers,
but I am not sure how to do this, and am hoping there may be an even better
way.
Thanks,
Nick M
error will have a unique "Error Number" that will be used to track the
status of the equipment. I currently am assigning this number using auto
number. I am starting to think this may not be the best way as I will have
multiple users contributing data.
The biggest problem is that the users will only be updating the database
from their computers every few days and do not have the ability to access
the main database for each record entry. My solution to this may be to
simply start each person's error number at very different starting numbers,
but I am not sure how to do this, and am hoping there may be an even better
way.
Thanks,
Nick M