Stored Calculation versus Auto-Enter Calculation for text for concatenating the full name
Is there any difference between these two? I do know that there is a difference between a stored and an unstored calculation; namely, that search speeds will be faster with a stored calculation, and indexing is allowed, at the expense of a larger database.
But whether there is a difference between a stored calculation field (where the calculation result is text), and a text field with an auto-enter calculation (and replacing existing value is allowed).
Might there be some slight difference, like, for example, perhaps in exporting the database to a text file. I can't think of all the possibilities for a possible difference, so hopefullly someone will point out a difference, or indicate, that there is no real difference.
I'm just wondering about when you are concatencating a full name from fields of firstname, middlename, lastname, which are all in the same table. But if someone has something to say about when concatenating fields from a related table, if this makes a difference, please reveal the mystery.