I have a table with the fields Model#, ProdLine, and StdHours. The last two are empty right now. I need to take the model number for each record, then I need Access to check the first two characters of the model number field, and depending on what the letters are it fills in ProdLine with the correct type of truck. For example( Model# = DR5252B001, so ProdLine = 'Drill Rig'). Is this even possible??![]()