Hey Richard, Glad you like my input on other classes for later as well. I'll try to mapp this out for you be easier if I could attach a excel sheet but here goes.

Position number is the employees job title and is assign to each employee.

Example 890 - computer programmer 999- office clerk 787- Network administrator

As I was stating I've used this a the key for it ties all the tables together from the different systems. Only catch as I forgot that when a fulltime employee changes positions I can run into a issues as I have had. The other system which is our HR system changes these number anything a employee may get a promotion or apply for a better paying position and receive it. Well that is what happen and when they may a change and it occurs after payroll(the other system) has already processed the payroll it has their old position number and now the new and old are out of sync. What I have is a report that shows the Names and position number from each table in their own column so that it can be compared and once found can be corrected so they match again. They are to add the new position number in the personnel table each time a new employee is add or changes position as in this case. For when they do this them link two table for sure as these are their personnel table and the HR table thus leaving one record in the pay table to change verses many records in the HR table which is the hours work on each day so this could be up to 20+ records as these records are also for different type of attendance (Reg hours, Sick leave, Annual etc) so this makes it much each to fix if their personnel table matches HR table and that way its only one record in pay record that needs to change to make all three match again. So does that shed a little better light on the issue. Just trying to come up with a way to automate this so I don't have to do a manual adjust to pay table if there is no Position number to match it to if there is a change as I described. The pay use confidental data to tie all the benefits but I can use that or nor do I dare as the less I can us this the better our data is protected. I can send you a small sample of thise MDB as one is only for like 4 people but saves a person about a days worth of data processing that was a manual process using time sheets, payroll registers and maintaining it in excel and was done once a month for each employee and was so time consuming a process that at reporting time it was a 2-3 day process. So by monitoring this once a month in my MDB and if only fixing one record a month is going to be a issue for now this is 99 percent faster and more efficent than before. Be nice to show off what I've learned from your classes as well for I would say 95% of what I have learned is from your 599cd courses. That's how good they are and why I recommend them to all my friend and user who are just learning Office. Just not a big word fan as I'm not into fancy as TOC and Fancy formatting as I like to do my own structure as I have more control on the formatting it seems to me. Kind of like your classes on building form menus rather than using switch board although 2007 is a pain at times finding everything to set controls. But some I like as in the new saved imports/Exports in Access. Just need to figure out if theres a way to automate that list to run rather that click run tab click run. But it's sure better than click browse save as. For one click yes yes and ok and the file is run and stored just where you want it stored. Nice feature and time saver too. Let me know if more is need to help see if you have a solution in one of the classes which I'm thinking me be there but then again I've read and watch so much of the classes lately and working on this MDB's It's been a load but great to finally get back to your courses and refresh this ole brain so it still functions. That's a miracle in itself :-) Thanks again for the great work you do and look forward to seeing more and getting into that new Security class as I see it may be great for the new payroll program I need to write as it's time to can the old Foxpro 2.6 program and use something a little more user friendly as this coding take a lot of time and whole new learning curve when your using access all the time. Also I only did FP for a little while and I'm the only one doing these programs for our division and FP no one knows and I'm not no FP programmer but can figure it out as I have been when minor changes have come up. But enough on that and thanks again and sorry for going on and on but this is what I enjoy and maybe before I'm called home I'll be almost as good as you. Thanks Steve