Search results

Thanks once again. I have been looking at using the index function to avoid duplications across multi fields. This seems to resolve my concern. Another issue I have experienced is when using lookups to tables to enable the user to see a meaningful piece of data rather than the auto number...

Hi, Thanks once again for your structure. I have set the tables up as described but am yet to test the system. One question I do have is in the tblProjEmpRates: -pkProjEmpRatesID primary key, autonumber -fkProjEmpID foreign key to tblProjEmployees -currRate -dteEffective (effective date--i.e...

Thanks you for your help; you have spent some time in assisting! I will change my structure as I now understand that my tables were not correctly normalised and see how I get on. The rate issue. Each employee has an internal rate which is know as a target rate. This is the rate the...

Hi, I am inexperience with databases and access and would welcome some assistance on a problem I am having with my table structures. From our time sheet system I am able to get a dump of employee ID, date , hours, cost code, etc I have been able to link this to employee name and cost code...