I need to create unique ids for records in databases that I want to make part of a larger relational database. I thought I found the answer the replies to the “Setting up relational database” post. See screenshot. However, the formula did not work. I got the same result to the formula no matter which record I was on.
Also, I read in the function description that while the id is guaranteed to be unique, that does not mean is is unchangeable. If that is true, it would not be helpful in this application to database relationships.
I don’t need this value now as I have unique ids from my imported FileMaker database. However, as I was trained, it is always good practice to create unique record ids, as well as creation and modification dates and users, in case one wants to make their database relate to others, and to have the needed security fields for multiuser environments.