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
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