Force Supernatural key value

  • 24 January 2023
  • 2 replies

Userlevel 3
Badge +1


I have a list that maps product_codes to product_ID's.

What I would like to create is a Key Store that, when fed a product_code from the list, produces the same product_ID and when fed a new code (so not in list) produces a supernatural_key as usual. 

Is it possible to force the keystore to create the ID's as shown above? 


Best answer by fwagner 24 January 2023, 16:57

View original

2 replies

Userlevel 2
Badge +3

Hey @sierd.zuiderveld 


thank you for your question! 🚀


Yes, you can absolutely do that, and it is exactly what a Key Store does.


So the two steps to accomplish this is to

Adding a Key Store (based on Product_Code)

and then Adding a Supernatural Key Field which will look up the Product_ID.


Does this work for you?


Best Regards,


Userlevel 5
Badge +5

Hey @sierd.zuiderveld, did you manage to resolve the issue using the steps recommended by Frank above? If so could you please mark Frank’s answer as best answer? This can be done by clicking “Best answer” as shown below.

 If you are still are unable to solve the issue, please let us know