I have a file with several thousand event records. Each event is assigned to one of several hundred managers whose name is in the Manager field.

I wish to automate a process which does the following:

1) Create mutliple copies of the file.

2) The individual files created contain the records associated with each Manager only (i.e. Smith's file contains 10 Manager="Smith" records).

3) The filename would contain the manager's name and the enclosed record count (i.e. Smith_[10]_Fall_05.fp7).

Can anyone suggest a best route to take? Many thanks in advance.

DSW

Why not just make a UI Table at the begginning that requires they punch in thier name, then relate it to everything and they will only see those that pertain to them?

Does each of your Managers have FM?

Thank you for your response.

For a number of reasons (i.e. portability, backup's), in this case anyway, it is preferable to have individual files.

DSW