Move Determiner to Determiners

[SPalpurina]

Hello,

Adding the Determination table as a one-to-many relationship into the view form works fine for working with new records. However, all the information stored in the original one-to-one Determination field is lost (or at least not accessible in the Determination table). How can I transfer efficiently to the new Determination table?

[lexiclevenger6]

Hello,

Unfortunately, since they are different tables, the data does not carry over. We are planning on implementing a batch-edit feature, which would allow you to transfer the data from the Determiner to Determiners table for all applicable records. Until then, in order to display the original Determiner data on the form, you may leave both the Determiner query combo box and Determiners subview on the form. If you want to discourage users from entering data in the Determiner field when creating new records, you can also make the field read-only by adding the attribute readonly="true" in the view definition.

[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!