you could set the value fo the column using the rnd function in the forms before insert code block
... but you'd need to do soem more work to make certain that the proposed value had not already been issued (hint set a unique index constraint on the column.
OR use a numbers table (containing just a column with the numbers 1 to 500 in
use a left join from the numbers table to the other table... setting a where clause to the main table = n ull will give a list of available (unused) numbers. select top 1 with an order of RAND shousdl do the job
bu8t it does beg the question what makes you want to store a random number for 500 rows.
I'd rather be riding on the Tiger 800 or the Norton