Looking up time zone in table and displaying on form

C

collierd

I have a main table - consumer contacts in which we enter consumer data which
includes the telephone number. I have another table which relates area codes
with time zones so that we know when it is appropriate to call consumers in
different areas of the country. I need to know how to add a field on the
consumer contact form that will display the time zone when we enter the
telephone number. (Note: We had this set up in Access 97, but we recently had
to convert to Access 2003 and lost this functionality and the person who set
it up is no longer here).
I'd appreciate any help.
 
Top