I´m quite sure it has been asked before, I looked, but I cannot find it: I would like to change the Main Key, but it is greyed out in DataManager on every field.
The underlying problem is that I have a 1-n relationship. For the n-part, I do not need the Title field, just the Ref to the Main collection. If I leave the title field blank, DataManager finds no entries when wanting to choose a Main row per Detail row.
The main key must be of type Text
J.D., thanks, but I still don´t get it. In a 1-n relation, every n-row already has its own Primary Key (the _id). In a standard Order DB, you would refer from N-level (detail) to 1-level (Main) using the Main´s Primary Key (=_id) as a foreign key in Detail level.
So what is this “Main Field” (in Detail level) really. A secondary key? Can it be left blank using wix-data and still bind Main to Detail and vice versa?
Appreciate your help. Am designing a new DB. Some things changed while not watching. Earlier, Wix had a field called “Primary Key” on Main level. Which, I think, it wasn´t, it was just a DisplayField, to be displayed instead of some long alpha-numeric key. It´s gone now, I only see “Main Field” and grasping to understand its meaning.