syntax "last(select table)" issue

Hi,

 

I have small problem with this syntax.

Does the select statement of a record from a table only goes with the first last 9 entries?

 

I have a table of many about 100 records and ongoing (currency rates which will be updated every once a week) to pick always the latest one entry when creating a new record in another table.

Instead of manually choose the latest currency rate from the Currency Table, I created a button to auto select latest entry from that table when needed. The formula in the button "On click" is:

 

'Currency Rates' := last(select 'Currency Rates')

 

 

It seems however, that it only selects the latest of the first 9 entries of all and ignore the entries recorded afterwards.

 

 

 

 

Thanks for clarification.

Sebastian