[AccessD] select most recent

Eric Goetz EricGoetz at EGIsystems.com
Sun Feb 16 18:01:00 CST 2003


Hi,

 

I am thinking of the table as a history. I probably should have called
the table tblManagerAssignments. If a manager moves from one territory
to another, I would make a new record with the new start date. I could
have normalized the StartDate and TerritoryID out from the FirstName and
LastName.

 

If a manager leaves a territory, and there is a time when no manager is
assigned to the territory, the report should show "Open". I was
intending to handle this by creating a new record with the name of
"Open", and give the start date to be the date that the manager left the
territory. There would be many records with the name of "Open".

 

Thanks,

 

Eric

 

-----Original Message-----
From: DJK(John) Robinson [mailto:djkr at msn.com] 
Sent: Sunday, February 16, 2003 3:12 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] select most recent

 

Eric

I'm not clear what you intend in your design. For instance, if a manager
moves from one territory to another, then the historical record must be
lost, since managerID is the PK.  So is this table meant to be a
'current state' table, or a history from which the current state may be
deduced (which I think is what you are asking)?

John

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030216/02bf2531/attachment-0002.html>


More information about the AccessD mailing list