Calculation works on the test table, but not the one in use
I'm looking for some advice.
I've got a version of my database on one computer, which contains fake data that I use to try out tweaks and changes.
Then I've got another version of my database on another computer that is in use.
Obviously the two databases are not exactly the same, but they are very similar. I can get the calculation Last (History::Title) working great on the test database, but it won't work on the one I'm actually using.
The only difference I can see is that in the Fields manager, beside the one that's working under options/comments it says "Unstored, from S Database =" then gives the calculation, (yes, I have that same table on both versions), and the real one just says "Unstored, =" then the calculation.
Any ideas as to what I'm missing on the database that's in use?