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

 

[AccessVandal via AccessMonster.com]

Here's a link to auto fill textboxes.

http://support.microsoft.com/kb/319482
http://support.microsoft.com/kb/322900

If you wish to keep the old e-mail addresses as a record in table1 than
that's fine. If not, do what Jeff suggest.

 

[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?

 

[AccessVandal via AccessMonster.com]

Yes you can. You can use the afterupdate event of the textbox to fill the
email address.

The combo box was built for this so that the user does not have to remember
all the analyst initials. Would you rather let the user to scroll through a
hard copy or use the user’s memory?

 

[AccessVandal via AccessMonster.com]

Before you start creating a database I think you need to read up more on
design a database. Here's a beginner's guide.

http://home.att.net/~california.db/tips.html#aTip1