Recent content by ParachuteTechnology

In hindsight that would have been preferred, but TKFN works as the primary and foreign key here. I am already pulling the regular rate for 99% of the time entries based on a field in tblPeople. The 1% of cases that have special rates are the issue. The proposed solution would be a new, third...

tblTimeEntry records individual time slips for attorneys keeping track of their time. Each slip records the client, attorney, time, rate, and value (time * rate) of the slip. tblPeople holds all the timekeepers and their current rate. Their rates change once a year. tblCustomRate will hold the...

15 second video showing my problem (there's no audio): vimeo.com/83514937 Here is an image album of the problem if you'd rather not watch the video: imgur.com/a/6Iplb I'm running Access 2013 and have this problem in a couple different databases. It's annoying and it happens to all users of...