Hello All
I have done a little research and am wondering which would be best for the following scenario. I have multiple users coming into a database to add a change notification. The “Unique” identifier is to be formatted to 9999-9. This is numeric, first 4 numbers are a work order number and after the dash number is to be incremented by one based on the last entry (which may have been months to years ago, or never have had a change notification)
Also this needs to be available when copying the current record to a new record. (User has 5 work order numbers (not in sequential order) not the same work order numbers: 2626-1, 5658-4, 8595-2, etc.. I have a copy function that copies the data to new record and will have to be able to then search again for the last number used. (Requeried)
So if 2626-1 is the number of the new change the user would type in the 2626 and then using dmax or dlookup, find that no change notifications exist for this #, and the 2626-1 is added in the field.
This will be a database used by 15 or so people, but run on a network, and more than one person will be entering or searching for information at a time.
Any opinions appreciated!
Thanks
Raven
I have done a little research and am wondering which would be best for the following scenario. I have multiple users coming into a database to add a change notification. The “Unique” identifier is to be formatted to 9999-9. This is numeric, first 4 numbers are a work order number and after the dash number is to be incremented by one based on the last entry (which may have been months to years ago, or never have had a change notification)
Also this needs to be available when copying the current record to a new record. (User has 5 work order numbers (not in sequential order) not the same work order numbers: 2626-1, 5658-4, 8595-2, etc.. I have a copy function that copies the data to new record and will have to be able to then search again for the last number used. (Requeried)
So if 2626-1 is the number of the new change the user would type in the 2626 and then using dmax or dlookup, find that no change notifications exist for this #, and the 2626-1 is added in the field.
This will be a database used by 15 or so people, but run on a network, and more than one person will be entering or searching for information at a time.
Any opinions appreciated!
Thanks
Raven