Search results

thanks for the input! I agree simple is better, but i would like a bit more automation. Essentially I am the bridge between our Regan era cash registers and some kind of modern record keeping, so I do a lot of data entry. This is just one task of many. I have been (of course) using Excel until...

What is the correct form strategy to ease numerical data entry into a table that requires multiple records? tblHourlySales tracks the sales per hour of our store. Each record has 4 fields: pk CalendarDate Hour Sales At the end of the day I want to be able to enter sales using a 10 key pad to...

Thanks for the reply Dave/Gemma, If I hear you correctly. The values stored in that table, shouldn't be relationally linked to any other tables that are updated over time because the audit entry should not change. I.e. I don't want the entry for the starting wage to change when I change the...

thanks for taking an interest. Let me back up a bit: tblEmployees - name, address, wage, etc FK locations FK Jobs tblLog - date, wage change, notes FK Employee FK Jobs FK Locations FK Actions tbl actions - new hire, termination, raise, etc tbljobs - crew, manager, etc tbl locations -...

Hello. A question about designing relationships with an audit log. I am setting up a HR db. I want to create a table that records actions performed to employees. I am noticing that my relationships are growing more complex and don't want normalization problems long term. TblEmployees...

"Hello world" I'm an excel junkie turned Access fanatic, but very new to the environment. I am slowly learning how VBA works and basic database design. As is typical for me, my aspirations are higher than my skill and the learning curve is slow. I have started with (what I thought would be...