Lookup? (2 Viewers)

[Karjoe]

Hi,
I have a field in a report that I update manually whenever we a new account
exec is added. it's like this:
If([Acct exec]="FM","Frank Min")If([Acct exce]="JP", "John Pepp",,,,,etc
Next time I have a new acct exce (MM) I update the report manually to show
the full name of the acct exec instead of the intial.
The name and the intial are stored in a table that's updated by a user. How
can I make the report or rather the query linked the report get updated
whenever a new exec is entered into the table?

Thanks in advance.

 

[pbaldy]

You would have both the "data" table and the "lookup" table in the query, joined on the common field. That enables you to include the name as a field available on the report.

 

[Karjoe]

Linkded the lookup table and worked. Thank you.

 

[pbaldy]

Happy to help.