Re: form field

Tech-Archive recommends: Fix windows errors by optimizing your registry

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



"Rpettis31" <Rpettis31@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:34BD5B0E-2004-4377-8D8C-26F700517662@xxxxxxxxxxxxxxxx
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.



.