Auto rate a clien with collected points base on a Rating table

[Simon]

Hi,
I have access tables collected points from my client and want to list all
clien with a colume list all customers rating automaticaly when open a form
base on the tRating table, but Rate field I can manually individual over
write them if need by other special factor. would this need a modules,
macro, or queries in my form? How to set the code?

2 table are: tClientInfo table and tRating table
tClientInfo table with 3 fields:
ClientID Point Rate
1 10 F
2 05 F
3 11 E
4 50 C <----- should be A but I want to over writed
to C
5 32 C

tRating table with 3 fields: MinRate and MaxRate from 1 to 100 may change
value from times, field SetRate values from A to Z
SetRate MinRate MaxRate
F 01 10
E 11 20
D 21 30
C 31 35
B 36 40
A 41 50

Thanks in advance.
Simon