Hi, I'm not having much luck tracking this down; not sure of the best keywords to use. For some reason I seem to have never run into this before...
I have an app which allows 5 tax codes to be entered (State, County, City...) for a Customer. Naturally, all 5 fields use the same table for drawing data. Logically like this:
Table_Customer.Tax_Code 1 -> Table_Codes.Description
Table_Customer.Tax_Code 2 -> Table_Codes.Description
Table_Customer.Tax_Code 3 -> Table_Codes.Description
Table_Customer.Tax_Code 4 -> Table_Codes.Description
Table_Customer.Tax_Code 5 -> Table_Codes.Description
Simply, how do I get Table_Codes.Description for Table_Customer.Tax_Code 2, 3, 4, 5? If I just use Table_Codes.Description, I only get Table_Customer.Tax_Code 1...