topic Assigning random numbers to customer numbers/index in App Development

Assigning random numbers to customer numbers/index

Thu, 04 Feb 2016 11:08:55 GMT

Hello,

I'm trying to assign random numbers to my customer numbers. 1st step was to index every customer number like this:
autonumber (sCustomerNumber) as [Customer Number]

The 2nd step is to assign each and every index with a number between 1-1000.

Can anyone share with me how to do this? 😃

Sincerely,

Betty Habtemariam

Re: Assigning random numbers to customer numbers/index

sunny_talwar — Thu, 04 Feb 2016 17:36:37 GMT

UPDATE: I don't think this is going to work

May be this:

AutoNumber(sCustomerNumber) * Ceil(Rand()*1000) as [Customer Number]

Re: Assigning random numbers to customer numbers/index

Fri, 05 Feb 2016 07:36:30 GMT

Actually it did work, haha! Thank you! So I was wondering if you could answer another question too.

If I would like to assign a product name with a number anywhere between 1-1000, how would I do that without loosing the products' name? (I've tried to do that, but the products' name disappear and is replaced with the numbers).

Sincerely,

Betty Habtemariam

Re: Assigning random numbers to customer numbers/index

sunny_talwar — Fri, 05 Feb 2016 18:02:53 GMT

May be this:

ProductName & AutoNumber(sCustomerNumber) * Ceil(Rand()*1000) as [Customer Number]