Move Determiner to Determiners

[Grant]

Hi @SPalpurina,

You can easily migrate the values from “Determiner” to “Determiners” if you have an IT administrator on site with SQL access to your database. Instructions are below:

Migrate Determiners to the 'Determiner' table

Important: These steps can and should only be performed by IT users. Remember to make a back up of your database before performing any actions in the command line. There is no simple way to reverse this action. The Specify Schema 2.10 update introduces the new Determiner table to the database schema! This highly requested feature allows you to add multiple determiners to a single determination record. For databases that already have determiner data in the determiner field in the Determinatio…

Once that is done, you can remove the determiner field from your forms and hide it in the schema. All of the single determiners will be moved to the one-to-many!