Having a condition in column

[Guest]

Hi, I want to know if it is possible to have data inserted automatically in
another column based on the data entry in one column. In my database, I have
the following columns:

Country
Region
Economy

SO I want to know if by entering for instance Senegal in the Country Column,
SSA will appear in Column Region and Low income in the Economy column?
Hope I am making sense here.
Is there a way to desing a macro may be for that to happen. I have
thousands of data in this database and I can always remember the region and
economy for such and such country.
Thanks for your help
M

 

[Guest]

Are you thinking of a cascading combo? This limits the information in the
following combo depending on what is in the first combo?

 

[Guest]

Hi Scubadiver,

Sorry, I am an ignorant! what is a cascading combo? Thanks
M

 

[John W. Vinson]

Hi, I want to know if it is possible to have data inserted automatically in
another column based on the data entry in one column. In my database, I have
the following columns:

Country
Region
Economy

SO I want to know if by entering for instance Senegal in the Country Column,
SSA will appear in Column Region and Low income in the Economy column?
Hope I am making sense here.
Is there a way to desing a macro may be for that to happen. I have
thousands of data in this database and I can always remember the region and
economy for such and such country.
Thanks for your help
M

No macro is needed. A Query will probably work... but how is Access supposed
to know that the Economy column should be "Low Income" for Senegal and "High
Income" for Sweden? Where does that information reside? Are you trying to
store these additional fields from the Country table into another table? If
so, DON'T - it's neither necessary nor good practice to store data
redundantly!

John W. Vinson [MVP]

 

[Guest]

If I had departments in a business each with lots of employees then I can
choose the department in one combo and then select an employee in the second
combo who work only from that department.

The other thing you might be thinking of is selecting a country in a combo
box and then using additional information in that combo to fill other text
boxes.

I would assume each country has a number of regions and each region has its
own economy.

What do your tables and relationships look like?

 

[Guest]

Yes, it is possible to do what you want, but you may need to clarify a few
things so people in this group will be better able to help you.

First, I might be wrong but it sounds like you are working directly in a
table. If that's the case, then that is your first problem. You should not be
working directly with the table as they are only for storing data, not
working with it.

You should be using forms and queries to work with and manipulate the data.
The solution to your problem may depend on other factors such as how many
choices you have for Country, Region and Economy, etc. If you post back with
some more specific information it will be easier for someone to offer advice.