Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can I use PK in QV?
is there something similar?
Thanks
A QV model is not a normal form database and does not use keys in the same way. You can certainly load PK values into QV, but if they are well formed 'no-information/logic free' keys, you may not need them in QV.
A key in QV is a field that exists in more than one table and is the basis of the association between the tables. A key may be designated as a "perfect key" in the table if there is one unique value of the key field for each row in the table and that is conceptually similar to a PK in a normal form database.
A QV model is not a normal form database and does not use keys in the same way. You can certainly load PK values into QV, but if they are well formed 'no-information/logic free' keys, you may not need them in QV.
A key in QV is a field that exists in more than one table and is the basis of the association between the tables. A key may be designated as a "perfect key" in the table if there is one unique value of the key field for each row in the table and that is conceptually similar to a PK in a normal form database.
Useful reading: QIX - A Forgiving Engine