form field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rpettis31 - 22 Apr 2008 05:42 GMT

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.

Reply to this Message

Jeanette Cunningham - 22 Apr 2008 08:43 GMT

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

>I have a form Customer Order with an item number combo box that looks up
>the
[quoted text clipped - 6 lines]
> Currently
> no value is retained in this field on the table.

Reply to this Message