Hello,
Hope this question doesn't file for the top 10 Most stupid Ones.
I have a table product and a table promotions. This last table has the primary key (Bcode) of the table products in it.
I also constructed a form in which I input the promotions for the products. To save memory I only save the BCode and not the field "productdescription" in the table promotions. Now, once I have inputted a promotion and I return to that record on the form I only see the 'BCode' and not the 'Description' in a text box.
How can I create a text box "control source" that links the Bcode stored in table promotions with the field "productdescription" in the table products, so that the field "productdescription" becomes visual on my form and not the field "BCode".
Thanks for your help,
Agamemnon
Hope this question doesn't file for the top 10 Most stupid Ones.
I have a table product and a table promotions. This last table has the primary key (Bcode) of the table products in it.
I also constructed a form in which I input the promotions for the products. To save memory I only save the BCode and not the field "productdescription" in the table promotions. Now, once I have inputted a promotion and I return to that record on the form I only see the 'BCode' and not the 'Description' in a text box.
How can I create a text box "control source" that links the Bcode stored in table promotions with the field "productdescription" in the table products, so that the field "productdescription" becomes visual on my form and not the field "BCode".
Thanks for your help,
Agamemnon