Michelangelo
Registered User.
- Local time
- Today, 13:28
- Joined
- Dec 20, 2002
- Messages
- 37
Hi,
My database is suffering from speed problems due a FE-BE where the BE is on the server.
It's a bussiness database where we keep record on the hours worked.
I keep all the work data in the BE.
For this specific problem I need to use three tables
- Hours, There are about 20.000 records in the hours table.
- ProjectFees - Table in which project dependable fees per employee are entered
- GeneralFees - Table where default fee per employee per time interval is entered (History of fees)
We need the possibility to change the fee in the General fee for one employee and one interval and update these in the hours table. BTW, I keep them in the table because of the rather complex determining of the correct value.
I solved it using VBA but it doesn't do it quickly enough. I am now thinking about a update query which does the following.
change the fee in hours table to
- if project exists in ProjectFees then use this fee (employee dependant)
- if not use GeneralFees, depending on employee and time interval.
I hope this is all clear and hear from you soon,
M.
My database is suffering from speed problems due a FE-BE where the BE is on the server.
It's a bussiness database where we keep record on the hours worked.
I keep all the work data in the BE.
For this specific problem I need to use three tables
- Hours, There are about 20.000 records in the hours table.
- ProjectFees - Table in which project dependable fees per employee are entered
- GeneralFees - Table where default fee per employee per time interval is entered (History of fees)
We need the possibility to change the fee in the General fee for one employee and one interval and update these in the hours table. BTW, I keep them in the table because of the rather complex determining of the correct value.
I solved it using VBA but it doesn't do it quickly enough. I am now thinking about a update query which does the following.
change the fee in hours table to
- if project exists in ProjectFees then use this fee (employee dependant)
- if not use GeneralFees, depending on employee and time interval.
I hope this is all clear and hear from you soon,
M.
