form field

[Rpettis31]

I have a form Customer Order with an item number combo box that looks up the
item numbers on an item master table. The Item description is basically a
text box =ItemNumber.column(2) which populates the item description when the
item number is selected. What I would like to know is how I would retain the
decription field into the same field on the Customer Order table. Currently
no value is retained in this field on the table.

 

[Jeanette Cunningham]

Hi,
the general idea is to avoid storing the item description in the customer
order table.
Just store the Item Number in the customer order table.
Use a query to retrieve the item description using the Item number whenever
you want to see which item description was ordered.

Jeanette Cunningham