This is my second thread for today and I am a very newbee but no one was born expert.
In my access database I want to relate tables through an Id number but when I open the "+" sing which is aside a certain field i want to see the name of the next field of the ID and not the ID number. For example in the sales table I record the code number of the product and the ID number of the costumer who bought it. But now when I open the PLUS sign in the coustomer table I want to see the name and not the number of the product.Please if anyone understands what I am saying, help me couse I Understand that I probably am not clear enough.

Thanks in advance, erion