Connect data in fields

[Cindy]

I would like to create auto fill information in one field when entering data
one field. For example, when I enter a drug name in one field, it
automatically fills in whether that drug is a vaccine, antibioitic or other
name I assign.

 

[John W. Vinson]

I would like to create auto fill information in one field when entering data
one field. For example, when I enter a drug name in one field, it
automatically fills in whether that drug is a vaccine, antibioitic or other
name I assign.

Why?

Storing this data redundantly is neither necessary nor good design. If you
have the information in the drugs table you can use a Query linking to the
drugs table to look it up.

Note that you should also be using a combo box to *SELECT* a drugname from the
table, rather than a textbox where the user can choose to type their own
imaginative variant spelling of methotrexate or methotextrate or metothrexate
or...