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

How to Create Custom Hash Keys in Jet Enterprise


Overview

Using the Jet Data Manager it is possible to create a custom hash key field in a table based on a combination of field values that can be controlled by the user.

Process

In order to add a custom hash key field to a table right-click on the table and select "Add Custom Hash Field".

The user will then check the boxes in the Custom Hash Key window on the right for all fields to be included in the generation of the custom hash key. In this example the hash key will be generated using the Company, No, and Name fields from the Customer table.


Note: The order of these fields is important as this will determine the hash key that is generated. A hash key generated with the order "Company, No, Name" will be different than the order "Company, Name, No" for the same record.
The field can then be renamed by the user and the table can be deployed and executed. The result will be a custom hash key that uniquely identifies the combination of values stored in the fields selected.


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

Comments