A 4-D nightmare :(

[manganese25]

Here I am with yet another problem. I have a customer database and a salesperson database that are related with a "Key" to allow relations between all records.

Problem: In the customer database, the sales slips contain a field for the salesperson's name which is selected through a value list related to the salesperson database.

I want to be able to calculate sales for EACH salesperson based upon a date range. So far, every employee is showing the TOTAL sales for the store and NOT broken down by employee

There doesn't seem to be a calculation function that can calculate a range of records with a conditional based on "salesperson" and "date range" in real time without some form of user interaction or having to "sort" the sales slips. I need to have all slips in an index at all times.

Pretend I have said nothing and have never touched FM Pro and am asking "How would you create a sales slip database and then create sales reports broken down by employee?"

Any help would be greatly appreciated

[Vaughan]

You may need to create calculation fields that can identify the particular criteria you are looking for. Then use Summaries to generate the reports.