table relationship

[ake]

I have two 2 tables with the following fields:
Table1:
1.Issue
2.Analyst Initials
3.Description of the Issue
4.Analyst Email Address

Table2:
1.Analyst Initials
2.E-maill address

I used the table 1 as the control source for a User form which i named Issue
Form. In this form I put all the fields that are in table 1. My question is
how can I automatically pull the email address of the analyst based on the
Analyst's initials So that when the user input the analyst initial the
analyst email address will automatically be in the table and form?

 

[Jeff Boyce]

I may be misinterpreting your description...

It looks like you are storing both the Analyst Initials and the Analyst
Email Address in two different tables. If so, why?

I can see how you might need to do this if you were working in a
spreadsheet, but this is not a good idea when you are working in Access, a
relational database.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ake]

ok, maybe i have to put them in the same table, thanks for that suggestion
but my question is what can i do so that when the user entered the analyst
initials, the e-mail address would be automatically populated. Is there an
alternative way rather than using the combo box?