Filling in Fields

[BigCat]

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??

[TheShabz]

Do you have a table that tells you that DR means Drill Rig or are you planning on hard-coding it into your query?

[alansidman]

I would create a table that lists all the model numbers in one field and the ProdLine in another field. Then if you use a combo box to select the model number, you can then reference the column for the ProdLine in that control based upon the model number selection.

Assume your table has three fields
ID
ModelNr
ProdLine

In your text box for the prodline you would put this formula
=ModelNr.column(2) The ID has column 0 in your lookup SQL statement.

Alan