Duplicating a database deletes internal references
I have duplicated a Database in order to start populating it with data from scratch.
One of the tables ('Selezioni') exists only to allow the creation of Cascading Dynamic Choice Fields.
When I duplicate the database, all the references to that table get lost as if Ninox couldn't find the table. Of course I haven't changed any table's name.
In the dynamic value field I get
let xTipo := number(YA); let xArea := number(T8); let xLiv := number(V8); ERR("Tabella non trovata: BB")[A = 4 and H = xTipo and B = xArea and C = xLiv]
where there should be
let xTipo := number(Contratto); let xArea := number(Area); let xLiv := number(Livello); (select Selezioni)[ContrattoCategorie = 4 and ContrattoTipo = xTipo and ContrattoArea = xArea and ContrattoLivello = xLiv]
This brings me to my second question: if I want to duplicate a database, how can I know which references will stay and which ones will be lost?
Interesting, I duplicated a DB with dynamic fields and they duplicated fine. They didn’t lose their connection or anything.
Can you create a temp db and try it again?
You can always not duplicate the records. Then just import the data for the dynamic choice field separately.
- Status Answered
- 1 yr agoLast active