>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!
Inge,
Use a combobox. ie:
.Rowsourcetype = 3
.Rowsource = 'select Descr,productid from products into cursor crsProducts'
.Columncount = 2
.BoundColumn=2
.Columnwidths = '100,0'
.Controlsource='YourTable.ProductID'
Cetin