I have two tables:



tblManagers with Manager ID (primary key), address, HR-ID, Bday etc.

tblDistrict with primary key as an autonumber, Manager ID, district, start date, end date, end reason.

I am trying to set a query for the two tables with Manager ID as the "join". I have a form that needs to be based off of this query that will show all of the Manager info plus the District. The districts change "often" and we will have temporary managers, etc.

in tblDistrict every time someone starts or ends an assisgnment they get a new record. It needs to be this way because they constantly change.

Is there a way to set the query to pull the LAST updated record in tbldistrict that would not duplicate the records so my form will be updatable.

Thanks!