Your question isn't exactly clear, but if you're asking if you can reference the value stored in a field in a related table for a calculation field in the current table, the answer is "yes".
Thanks for your reply, I'm trying to create a table containing a few email templates e.g.:
Record 1: "Dear " & User_List::Name & "¶ Your score is " & User_List::Score
Record 2: "Dear " & User_List::Name & "¶ Your account will be expired on " & User_List::Exp_Date
The purpose of the list is that I want to easily edit (and keep several versions, so as to reuse in future) of custom emails.
Is it possible to specify indirectly the calculation formula from the content of a field stored in another table?
Yes - that's what the Evaluate() function is for.
I'm trying to create a table containing a few email templates
I'd suggest you look at some demos:
Many thanks to your reply. It will keep me busy for several days.
I've just got my copy of FMPA for a couple of days and is completely new to it. However, the quality reply I got from this forum have already impress me enough that I have made a right choice.