I am building a form which will be used to enter simple item descriptions. I have a question about two of the fields. When the [ItemNumber] field is entered on the form I want to automatically fill in the [ItemDescription] field on the form. The item descriptions are contained in an unrelated table.
For example, item number 20xxx is a "40' Box Car Single Door". 20xxx is in the [ItemSeries] field in the unrelated table. Item numbers in this series could range from 20001 to 20999, but they would all be 40' Box Car Single Door".
What do I need to put in the [ItemDescription] field on the form in order to accomplish this? I am stumped.
For example, item number 20xxx is a "40' Box Car Single Door". 20xxx is in the [ItemSeries] field in the unrelated table. Item numbers in this series could range from 20001 to 20999, but they would all be 40' Box Car Single Door".
What do I need to put in the [ItemDescription] field on the form in order to accomplish this? I am stumped.