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!