link data in access fields

[Cindy]

I need information from field to link to another field in an Access Database.
Example: If I enter Banamine in field one titled "drug name", I want field
two titled "drug type" to automatically fill in the world analgesic.

 

[John W. Vinson]

I need information from field to link to another field in an Access Database.
Example: If I enter Banamine in field one titled "drug name", I want field
two titled "drug type" to automatically fill in the world analgesic.

Why?

That would seem to be redundant. You should have a Drugs table with the drug
type as a field; the drug type should exist ONLY in that table. You can
display it elsewhere as needed by using a Query joining on the appropriate
unique DrugID (the insurance industry has standard drug codes). You should not
need to copy that value to any other table.

Am I misinterpreting your application?

 

[Cindy]

I occasionally prepare a variety of reports utilizing different fields from
this database that I export into Excel spreadsheets. I do not want to
memorize the numerous drug types that are associated with the drug names so
was hoping this information would automatically pop up in the desired field
in one uniform database. I have been told it can't be done but thought
perhaps they were wrong. I have separate tables for different fields that I
have. Thanks anyway.

 

[John W. Vinson]

I occasionally prepare a variety of reports utilizing different fields from
this database that I export into Excel spreadsheets. I do not want to
memorize the numerous drug types that are associated with the drug names so
was hoping this information would automatically pop up in the desired field
in one uniform database.

I'm not suggesting that you memorize anything.

I have been told it can't be done but thought
perhaps they were wrong.

They were indeed wrong.

I have separate tables for different fields that I
have. Thanks anyway.

Please explain your table structures. Having one table for drug categories,
and an unrelated table for drug names would be a mistake - the whole POINT of
a database is to allow you to have information about entities (Drugs,
Categories, Prescriptions, Patients, etc.) properly related. Your Drugs table
should either contain a field for the category of that drug, or (if each drug
can be in multiple categories) you will need a third table linking drugs to
categories. It's very straightforward (given proper table structures!!!) to
create a Query joining multiple tables to export one field from this table,
one field from another.