I have created a db that tracks equipment repair/expense. I have been asked
to create fields in an entry form that would auto-populate based on
information entered in another field.

If Equipment # = FL1 than Model # would be XM123 and Serial # is 654-321.

I have this information in a current table but can not get the desired
result. Help!


--
Never stop learning!