This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...