New to Creator, noodling a raffle generator
Greetings, all. I'm very new to Creator, and have mainly an old-style procedural coding and Access background, so my questions may be a bit...dated!
Anyhow, let's say I have a table with Name, Raffle Item, and Entries (for a number of raffle tickets). My old way of generating "tickets" and pulling a random ticket would be to iterate over the number of entries, adding the Name to a new table for each "ticket" and using the autonumber of the table record as the serial number, or perhaps the record position itself rather than the autonumber.
Now, I read about a 75-iteration limit, but I'm not sure that my old method would be the smartest way of accomplishing this nowadays, anyways. I read briefly about lists, and maybe my answer is there.
I suppose another method, without creating a list, is to just add the number of tickets for a specific item, then divide each individual entrant's number of tickets to obtain a percentage, then just generate a random number from 1-100 to pick a winner. For example:
Bob- 10 entries (16% of the entries)
Mike- 20 entries (34%)
BIll- 30 entries (50%)
60 entries total
I suppose that I could then just pull that random number and use the list above to pick a winner. Say the number was 47. That would mean Mike is the winner.
Thank you for your patience and for reading this mess, and I appreciate whatever input you offer. I'll be tooling around in Creator and hopefully learning something useful!
George R.