I use an access database to run my small business. My employees fill out an online time-sheet through Google Docs that is totally separate from access.
I would like create a time sheet system that access can pull data from. The main issue is the time sheets entries are all attached to one particular client... who they were working with for that hour.
The end result is I would like a button on an access Customer Form. When that button is pushed, it searches all the online timesheets and tell you which employees have logged hours to that particular clients. All of our access clients have a unique client number. I could very easily have my employee's write this number for every hour worked.
Any idea's of how to make this happen? It doesn't have to be real-time. As long as it can be accurate to 1 day. Ie: If the data is synchronized every night.
At this point just looking for general direction as to how to get this done. Roughly 100 employee's and 1,000 clients.