Thanks for the advice. I would be happy to use the calculated field datatype, however it is limited on the functions one can use and my calculation requirements are not supported.
Your second option is interesting but how do you limit the query calculation to apply only to a new record being...