I have 2 tables: ordertable (stores product id), & producttable (to lookup product id for product name). I have a text field on a form that should display product name instead of product id.

Sample record from ordertable:
orderNo: 90119 productid1: 392 productid2: 574 date: 04/04/03

Sample record from producttable:
Productid: 392 Descr: 17” monitor
Productid: 574 Descr: 13” monitor


I’d like my text field to display 17” monitor & 13” monitor instead of 392 & 574 (& there are 10 different products to be displayed in the form). Ho do I do this? Thanks all!