If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Default selections in a table
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 |
Thread Tools | |
Display Modes | |
|
|