I am looking for a method to generate non repetitive random numbers with filemaker.

to produce a random number between 2 integer values I use this formula:

min + round(random *(max - min), 0)

With a simple looping script, it is obvious that I am likely to get some identical values..

e.g. for a range from 1 to 4 with 4 random numbers I might get 3 2 3 1 - but I would like to get something like 4 2 3 1 (with no repetions)

How can this problem be solved with filemaker?
Any suggestions greatly appreciated.