Default selections in a table

Hello,

Suppose Columns A and B in Table 1 contain an industry name and industry
code, respectively. I then create a Table 2 which has drop down lists in
Column C to select industry names from Column A in Table 1. Can Access
automatically fill in the corresponding industry code into Column D of Table
2 that matches the industry name I selected in Column C?

Hopefully this makes sense.

Thanks!

On Tue, 23 Dec 2008 10:48:01 -0800, Brutalius wrote:

Hello,

Suppose Columns A and B in Table 1 contain an industry name and industry
code, respectively. I then create a Table 2 which has drop down lists
in Column C to select industry names from Column A in Table 1. Can
Access automatically fill in the corresponding industry code into Column
D of Table 2 that matches the industry name I selected in Column C?

Hopefully this makes sense.

Thanks!

Normally you would only copy ONE of those field to the related table and
use lookup mechanisms to display the other one. Just guessing but
typically the Industry Code would be the primary key in Table 1 and that
would then be the field you use as foreign keys on other tables.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com