AnsweredAssumed Answered

Creating Relationships for Sales Report

Question asked by donjuancarlos_1 on Nov 4, 2009
Latest reply on Nov 4, 2009 by philmodjunk


Creating Relationships for Sales Report


FM10 - I need help creating a sales report that will list the Slaesperson and the transactions that they have had for a specified period of time.


Salespeople database has Salespeople info

SalesTransactions has the individual sales transactions for each sale.


I know I need global Start Date and End Date fields and  ≥  relationships between them and the transaction date in the Salestransactions database, but I am stuck there.