Lock historical entries

[pwicr]

I have a table of Dealers. Each dealer has a REP. I want to CHANGE the rep of the Dealer going forward but RETAIN the historical.

How do I do that?

 

[John Big Booty]

How a bout a table that hold your Dealer Rep, it might be structured;

TBL_DealerRep
DealerID (FK)
RepDate
DealerRep

You could then simply show the Max of RepDate.

 

[pwicr]

How a bout a table that hold your Dealer Rep, it might be structured;

TBL_DealerRep
DealerID (FK)
RepDate
DealerRep

You could then simply show the Max of RepDate.

For RepDate. Use date field i presume. And enter the start date of the rep or the end date of the rep?

 

[pwicr]

and where/how would I enter "Max of repdate"?

 

[John Big Booty]

Have a look at Totals Query, use that to populate a sub form containing rep.

Does Rep expire after a set period or does it simply get replaced by the following Rep Date