Formula to look up a corresponding field from a related table?

Worked like a charm!!!

Yes, the Code is a text field.  What you suggested basically created a surrogate field to stand in for the Code field that is being manually entered.  Once I set up the relationship as you described, I made the Description field on the data entry form a lookup field where the reference is the formula text field and the value is the Description from the related parent table.

Thank you so much!  I've been racking my brain for days trying to figure out how to make this work.  Much appreciated.