Windows 7 32bit 
Access 2010 32bit
Hello everyone,
First I would like to thank you all for being an active community who's already guided me immensely.
I am very new to database design and application building. I work as general office support for a very small non profit. I have been tasked with developing a database to track HR and timesheet data and turning that into benefit reports. Actually, I was asked to create some spreadsheets to do this - but I strongly feel that access is a better solution than excel for this as we have around 150 individuals to track between all staff (part time, temporary, fulltime etc + regular volunteers).
So, the wall that I've hit that brings me to actually post instead of just search....
Some of our employees have more than one position, and in turn more than one rate of pay per month.
I created a compensation table that has the employee ID (from the employee table) and fields for position title, rate of pay and if that is per month or hour
I have a main timesheet table that assigns employee and month; and a details table that takes the timesheet ID and compensation ID with fund codes and hours worked.
My problem is that I don't know how to limit the combo box on the details sheet to just the positions assigned to the employee ID that matches the timesheet being worked with.
I tried all the design view access query (and my very, very, very limited SQL) options I could think of to limit the records in the combo and I always end up with all positions/rates of pay listed with no regard to employee ID.....I am missing something. (left join?......where clause???magical,enigmatic coding that is beyond me.....)
My actual database is pretty large and has other tables/forms and such that are(seem to be..) working as planned; so I've attached a mock up-sample thing -- If anyone has time to look at my general set up and point me in the right direction it would be most appreciated.
If not - you guys have already been a ton of help, so I will assume I'm missing something obvious
Reply With Quote
