If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
form field
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. |
#2
|
|||
|
|||
form field
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" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|