Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

How to add a Hashed Primary Key Control Field using Jet Enterprise


Overview

Having a Hashed version of the primary key can speed up lookups from other tables, especially if the primary key consists of multiple alphanumerical fields.

Process

1. Right click the table → Advanced → Advanced Settings .


2. Check the box for Enable BK Hash Key .

When checked, the Jet Data Manager will generate a Hashed version of the Primary key fields(s) using the SHA1 Hashing Method. If no primary key is selected, then the BK_HASH_KEY will contain a hashed version of the DW_ID Field.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments