AnsweredAssumed Answered

Creating prize file database for lottery style cards

Question asked by MsJoanne99 on Jun 23, 2009
Latest reply on Jun 25, 2009 by mrvodka


Creating prize file database for lottery style cards


I am trying to determine if Filemaker Pro is the correct program to purchase for creating database files used to created a lottery type game card. An example of what I need to be able to do, and have not figured out yet, is create a data base with a set number of records, say 3752, with a "Prize" field containing "A" 413 times, "B" 338 times, "C" 188 times, "D" 38 times, "E" 28 times, "F" 9 times, "I" 2250 times and "H" 488 times. The A, B, C, D, E, F, I and H needs to be randomize throughout the file. The records need to have a field that is consecutively numbered and I have figured out how to that and I have written a script so that I can create the 3752 files, with the consecutively numbered instantly by running the script, but I can't figure out how to put together a formula or write a script to fill my "Prize" field with "A, B, C, D, E, F, I or H" a specific number of times and randomize them throughout the entire population of the data file, please help!