Ashley75,

Like Shestakov said, use NOCACHE or follow Jeff's advise;
drop it and re-create it appropriately or perhaps, you may want to look into AQ option.

In some cases, programmers would create a table to store
the last value and write a function and call the function in a trigger or call it in the front-end script.