Value Range / Foreign key constraint

#1

Hi

I am trying to put together a test data suite using your wonderful tool. Therein, i have created a customer master table, and have defined customer IDs.

Now, in the transaction dataset, my customer id can only come from whats available in the Customer data set (customer id column).

How can i achieve this within your tool’s framework ? Suggestions ?

thanks

#2

Have you selected Dataset Column as the field type? Once you do this you can select for the values to come from a field in that dataset. You can select the distribution - I normally use random, but others may suit you better.

1 Like
#3

thanks a ton. Didnt realize it was implemented and in such a simple way.
works fine for me.

#4

You’re welcome :slight_smile: