I am familiar with that command, however, we want the email address that is associated with the account name to be displayed in the field.
Table 1 contains the data and layouts where we want the email address that matches the users Account Name to be displayed in specific field. We always want this field to be updated with whatever account is logged into filemaker
Table 2 contains a list of all of the users, their account names and email addresses.
Set up an unstored calculation that uses Get (accountname) to return the current user's account name.
Define a relationship linking that field to the account name field in table 2.
Table1::cAccountNameField = Table2::AccountName
Now place the email address field from table 2 on your layout.
Thank you PhilModJunk.
One quick question:
1) The unstored calculation is executed in a regular field, not a global field, correct?
It's a non-issue. Just define it as a calculation field, click the storage options... button in the specify calculation dialog and select "do not store...". You'll find the field options that could define this field as "global" aren't available.