C
chanu
I have a table that gives the rates of Dearness Allowance.These rates are
given for different periods in percentages.
ex: 01-01-2009 to 30-06-2009 37%
01-07-2009 to 30-11-2009 45% etc..
This is the default table and is applicable to almost 95% to 97% of
employees. I want to make a duplicate of this table and display it in an
unbound subform ( which is a continuous form). If the user makes any changes
in it, it is then clear that Default rates are not applicable to him. Then, i
want to store the data in a new table tblDeviations where i will store the
EmployeeId also as a special field.
when i will want to calculate Dearness Allowance, i will first search for a
particular employee in the tblDeviations. if it is not found there, it is
clear that he has default rates. then, i will use the default rate.
The Default table has the following fields:
FromDate ToDAte DearnessAllowanceRate
tblDeviations has another field extra
EmployeeID FromDate ToDAte DearnessAllowanceRate
My specific doubts are:
1. how to make a duplicate copy and set it as the recordsource of the subform
2. To compare this(after the user makes changes, if any) with the Default
table
3. Next time the user opens this form, the recordsource need not always be
the default if he has made changes to it before or in otherwords if his ID
exists in tblDeviations, the form has to display this changed data.
Being new to programming, I heavily rely upon your help. So, any help will
be gratefully appreciated.
given for different periods in percentages.
ex: 01-01-2009 to 30-06-2009 37%
01-07-2009 to 30-11-2009 45% etc..
This is the default table and is applicable to almost 95% to 97% of
employees. I want to make a duplicate of this table and display it in an
unbound subform ( which is a continuous form). If the user makes any changes
in it, it is then clear that Default rates are not applicable to him. Then, i
want to store the data in a new table tblDeviations where i will store the
EmployeeId also as a special field.
when i will want to calculate Dearness Allowance, i will first search for a
particular employee in the tblDeviations. if it is not found there, it is
clear that he has default rates. then, i will use the default rate.
The Default table has the following fields:
FromDate ToDAte DearnessAllowanceRate
tblDeviations has another field extra
EmployeeID FromDate ToDAte DearnessAllowanceRate
My specific doubts are:
1. how to make a duplicate copy and set it as the recordsource of the subform
2. To compare this(after the user makes changes, if any) with the Default
table
3. Next time the user opens this form, the recordsource need not always be
the default if he has made changes to it before or in otherwords if his ID
exists in tblDeviations, the form has to display this changed data.
Being new to programming, I heavily rely upon your help. So, any help will
be gratefully appreciated.