I have a table of rates, starting miles and ending miles and a lookup field that looks up the rate from the table. I've recently updated the rates and mileage on the table, the field doesn't seem to be updating or only retrieves the updated rates for the first 3 rows. What am I doing wrong? I just updated the rates.
Thanks in advance