Dear All

I have a table "Rate" which consist on rates of different material (Approx. 550 materials).
these rates Change every month. For some calculation we have to retain all records of all months. so how I design table to control the situation. At this time the design of the table is as follow:
Index_no text
Description text
Rate number

If I include a new field namely " Month" then I have to inserted all 550 records for specified month. In next month the procedure will repeat and so on the table populate continuously.
how can I solve the problem.

Wasim