After update??

[raghuprabhu]

I have attached a small database. My organisation pays an allowance for knowing foreign languages. The payment is for two years.


The employee has to qualify by passing an assessment. He or she is paid according to the level of competency. There are four levels lower, intermediate, higher and advanced.


Every year on the first Thursday of November this pay rate changes (increases). Each person gets paid one year at a time.


I have a table called tblLPA. This table shows Language, level, date qualified from, date qualified to, date paid from and date paid to, LPA code, LPA amount.

These languages are in three groups, the allowances are in four levels and there are 28 languages.


My question is how do I automatically update the LPA code in table LPA after I select the language and the level? The data for this in table “tblLanguage”


Secondly how do I automatically update the Amount once I input the “date paid from”? the data is in table “tblLPARates”. I have to update the table “LPARates” in the first week of November.

Thanks in advance....

 

[Cronk]

Use update queries whose operation is in a button OnClick code.