Random record selection

Discussion created by blb1 on Jan 13, 2012
Latest reply on Jan 14, 2012 by comment

I need to create a script/function that will make a random selection monthly from employee records. I have an employee database and to accomodate contracts we need to do random drug testing of a specific number of employees each month. Each employee needs to be checked twice a year. I have talked with several consulting companies and no one has a filemaker solution. We are using Filemaker 11 and Filemaker 11 server. Any ideas? Suggestions? Thank you