Enter a product code and display a product description

[clares]

Hi All

Apologies in advance but I am somewhat rusty with Access and I'll do my best to explain what I am trying to acheive, many years ago I could do it.

I have a form based on a purchase order table and within that form I have a subform for purchase order lines. When I select a product code in the subform I would like to be able to display the product descriptin as well. Easy I know for many of you. I'm not asking it to be done for me but could someone be kind enough to point me in the right direction. I know that I shouldn't store the product description in the purchase order lines tables as this is redunant data.

Thanks in advance.

Peter

 

[alansidman]

Maybe something like this: Autofill