AutoLookup queries that automatically fill in data

[Marly]

I need major help here, please. I have a table called reforsm, another table
with Countries, andother one with Region and a final one with Income.

Countries are related to Income and region.
What I want to achieve is the following:
I want to have a query that will populate other column when I enter data.
For example, when I enter Canada , I want the field Income to automatically
be populated with "High Income" and the field Region to be populated with
"OECD", because Canada is a High Income country and the region it is linked
to is OECD.
I have tried to look at the explanation provided in the "help section" but I
can't seem to understand (too dumb!) so if anyone can point me to the right
direction, I would really appreciate it. Since I have to enter almost 250
countries all the time, and I have to make sure that the corresponding Income
and Region are entered.
THis would save me a lot of time.
Thank you for your help. Marie

 

[John W. Vinson]

I need major help here, please. I have a table called reforsm, another table
with Countries, andother one with Region and a final one with Income.

Countries are related to Income and region.
What I want to achieve is the following:
I want to have a query that will populate other column when I enter data.
For example, when I enter Canada , I want the field Income to automatically
be populated with "High Income" and the field Region to be populated with
"OECD", because Canada is a High Income country and the region it is linked
to is OECD.
I have tried to look at the explanation provided in the "help section" but I
can't seem to understand (too dumb!) so if anyone can point me to the right
direction, I would really appreciate it. Since I have to enter almost 250
countries all the time, and I have to make sure that the corresponding Income
and Region are entered.
THis would save me a lot of time.
Thank you for your help. Marie

If you are trying to copy the Income and Region fields from the Countries
table into some other table... DON'T.

Relational databases use the "Grandmother's Pantry Principle": "A place - ONE
place! - for everything, everything in its place". That information is an
attribute of the Country, and as such should exist *ONLY* in the Country
table; the only field that needs to be in reforsm is the country.

I'd use a Form (do NOT use table datasheets for data entry; they're not
designed for it) with a combo box to select the country. Include the Region
and Income fields in the combo box's rowsource query, and *display* (but don't
store) them on the form by adding two textboxes with control sources

=cboCountry.Column(1)

to display the second (it's zero based) column of the combo box named
cboCountry.

 

[Marly]

Thanks a million, I will follow your suggestion.
Marie