Cass
11-10-2005, 04:15 AM
Hi!
Is any good idea how to resolve changes history.
Example: Worker works today department X, next week department Y .... s.o
how to reflect the history worker movements between departments http://vbaexpress.com/forum/images/smilies/sad2.gif
first idea is when change the department field (combo box) then come up pop-up and ask dates when was the change and record it history table http://vbaexpress.com/forum/images/smilies/think.gif
now asking why pop-up - because the departments change was maybe yesterday or something like that.
Or is any better idea http://vbaexpress.com/forum/images/smilies/100.gif
Is any good idea how to resolve changes history.
Example: Worker works today department X, next week department Y .... s.o
how to reflect the history worker movements between departments http://vbaexpress.com/forum/images/smilies/sad2.gif
first idea is when change the department field (combo box) then come up pop-up and ask dates when was the change and record it history table http://vbaexpress.com/forum/images/smilies/think.gif
now asking why pop-up - because the departments change was maybe yesterday or something like that.
Or is any better idea http://vbaexpress.com/forum/images/smilies/100.gif