Updating Field With Random Text

[Leadcast]

Hi,

I have 2 tables. Table 1 has text values in the <sub>field with 25 records total. The Table 2 has several thousand records. I need to update a field in table 2 with random text values of Table 1 .

Trying to do this with the rnd(), but having a key violation I think due to the text/number conflict. Is there another way to do this?

Thanks

LeadCast</sub>

 

[Remou]

This:

[tt]Int((25 * Rnd) + 1[/tt]

Will return a random number between 1 and 25, which can be used to get a record from the small table, however, this seems quite an odd thing to do.