Totalsalesvalue is compared with price1, price2, price3, price4 and result is stored in 'indicatedrange' field.
The values to the 'field indiatedrange' should be upper1/3, middle1/3 and lower1/3. This filed is auto calculate based on 'Totalsalesvalue' field.
This process should take place before I add a record to the table. I guess the code should be in the form current.
I didn't create the database. Somebody else created the database and I am not sure why the table is not normalized. I guess I won't be able to change the table structure. Do you have any suggestions how to go about it with out normalization.