picking x number of entries

[kaceofgeminis]

Hello everybody this is my first post and sadly is to put in evidence that i have no idea what so ever about this. One week ago i was ask by my chief to make a database for the call-center and i use file maker because it was cool and easy to use beside to the scalability and compatibility with other sistems.

Now i´m stuck, my boss is asking me to enable a way to make a pick of 100 or any number of the entries of the data base to asign a caller but the best i can do is narrow a search wich gives me to many or to little info, i need to be able to make a pick of a ¨x¨ number of entries for assignament. that´s it.

Any help is apreciated.

[RalphL]

I assume that the purpose is to assign a nearly equal number of calls to each caller. One way you could do this is to use the Mod function. If you have N callers, take the Mod ( ID ; N). This will give you an integer from 0 to N-1. Assign the callers numbers from 0 to N-1.

[kaceofgeminis]

the thing here is that the call center is way to small i mean just 10 callers for starters and the database is like 6000+ and growing so if i do that it will split the database between 10.

what i need is a way to ask per example 100 records for each caller each day so they can work with out problems.

Thanks any how.