Hello,
I'm attempting to program a main datatable to pull model types from a seperate table or query when a serial number is entered. My goal is to have the user only need to scan the serial number into the datasheet to have the model description autofill and not be forced to select from a combo box as the model list is extensive.
The seperate "Models" table has three fields: ID, Characters, and Description.
Note: In the serial number format I am using, the fourth and fifth characters determine the model type (description). I have programmed a field within the main table (named "4th&5th") by using a calculated field (MID[SN],4,2).
Any help would be appeciated!