I have a Table Reps - that shows Rep, Manager, Start Date, Exit Date etc...
Also Table Manager - that has Manager, Start Date, Exit Date
AND Table Sales - - Customer, Rep, Manager, Amount, Date etc...
Right now it is working great - I have a Form to enter Sales that has a combo Box to choose Rep (No Manager choice because I figured that would come from the Rep Table)
Now - I realize that as tha Data ages - Or if I go back and dump last years info, that the Manager Assignments have changed - And yet when I pull a report on Last year's data I want to pull sales for Manager based on last year's assignments not the current assignments
Also - as reps leave and the exit date becomes not null, I want the ability to choose the filter for the combobox cboRep to have a include retired reps option (maybe a check box - if checked would add a filter comboBox row source by not null in exitDate field)
What do you suggest?