My question has been asked with variations in these forums, but I wasn’t able to get the results I wanted from what I found.
I am creating a new database for a museum. We want to give each object a unique identifier. None of the 3,000+ objects have...
There should be a very simple way to detect a duplicate number upon entry of a record. For example, we have a field called Object ID. It contains numbers like MI20, T14, AI34. This is the unique identifier field so we can’t have duplicates. How d...
I would like help, but in the form of supervised guidance. For example, don’t write all the code for me, but start me out with one line and tell me what I should do next. I know javascript (though it has been years since I used it).
I tried to do a few things and couldn’t even come up with the first line of text. I did create a second table that will populate a field with the abbreviation for the Object Type so that the first 2 characters of the auto-generated Object Number wil...
