Populate value from value entered in another field

[Tiger6115]

Hello, I am wondering what would be the best approach to automatically populate the value of a field [Industry] in a table after a user has entered the value in another field [IndustryCode] in the same table. The [IndustryCode] and "Industry" are stored in a separated table [2012IndustryCodeTable]. I have tried using DLookup and cannot get it to work.

Ex.

|IndustryCode|Industry|InvestigationDate|
|001 |Car |
|002 |Plane |

How can i get the [Industry] to populate the information from the [2012IndustryCodeTable] once a user enters the code into the [IndustryCode] field in a table? Any help would be much appreciated.

 

[boblarson]

1. If you follow good database fundamentals you would NOT be storing both of those (redundant data).

2. You should only be storing the CODE in this table and then using a query when needed to pull the Industry name along with the code. FYI - you can use a query in 99% of the places you can use a table.

 

[Tiger6115]

You're right, I don't really want to build it like this. But i'm putting together a quick and dirty database for this office which will show the users an Industry name as a convienance while i build the final more comprehensive Database. Until i can get the additional tables,forms, query's and reports built i need a way to simply display the industry in the table. There's 2,000 industry titles so i couldn't really do a combobox either.