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.