kriki: "User ID" tablerelation in NAV2013

[Blog bot]

In some tables there is a field "User ID" (ex. T45:"G/L Register".F6:"User ID"). Nothing new here.

That field has tablerelation <User."User Name">. Seeing something strange? No? Let’s go on.

Table 2000000120:"User" has as primary key "User Security ID" (which is a GUID). Do you see it now? No?

Do you remember that a table relation should always point to the primary key? And that "User Name" is NOT a part of the primary key of table "user"?

The field "User ID" in different tables is NOT always pointing to the primary key of the User-table. In itself, this is not really a problem because the field "User ID" is generally filled up automatically like in table 45.

But if you run a test on your database, you will get an error that field "User Name" in Tabel 2000000120:"User" should be part of the primary key.



Читать дальше