I have a query that pulls data from one table based on two criterias: Period and Year. I added a feild to combine the Document date with the company code. the problem I am coming accross is that the company code (a lookup feild)is displaying the data I key in and not the data it is bound by. How can I make the query display the bound data?
Example: PR Data uses a 3 Char code for a devition of the company, where Acct uses a 4 digit code for the same. I want to see the 4 digit code. PR = EJW Acct = 1000. My table I am looking up from has the Acct code as the Primary Key. In the lookup wizard I selected the Acct code Feild and the PR code Feild. I have the Acct feild hiden, and it is the bound feild. I thought that that would be the one that is displayed in queries and as the value of the record, but that is not what is hapening. In order to see the Acct feild I had to bring in the table that I sued to pull the lookup from, and link to the PR code instead of the Acct code. This confuses me. Help Please.
Example: PR Data uses a 3 Char code for a devition of the company, where Acct uses a 4 digit code for the same. I want to see the 4 digit code. PR = EJW Acct = 1000. My table I am looking up from has the Acct code as the Primary Key. In the lookup wizard I selected the Acct code Feild and the PR code Feild. I have the Acct feild hiden, and it is the bound feild. I thought that that would be the one that is displayed in queries and as the value of the record, but that is not what is hapening. In order to see the Acct feild I had to bring in the table that I sued to pull the lookup from, and link to the PR code instead of the Acct code. This confuses me. Help Please.
