Simple Question about Referring to tables

[KIDRoach]

I have just started using access yesterday and it seems like this would be pretty simple to do. But... I don't know how to do it.


I have two tables.

First table has two columns: County Number and County Road Mileage (80 rows)

Second table, the index, has two columns: County Names and County Number (92 rows)


Is there a way in Access for me to create another table that has:

County Number, County Name, and Road Mileage as three separate columns?


I would like the first table to be the base of the new table. Then, I'd like Access to look up the county number that's in the first table, and produce the county name and write it beside the county number...



How do I do this?

Thanks!

[RuralGuy]

If the County Number in the first table is the same number as the County Number in the second table then you can use the Relationship Menu to Join the two tables on that field. Then a query will display any of the fields in either table as if they were in the same table.

[KIDRoach]

Thanks!

I really appreciate the answer. But like I said, I'm a total beginner in access. The only thing I have right now (Pretty much the only thing I know how to do) is I have two tables.

One is with County Number and Total Mileage for that County


The other one is an index table in which I have the County Number, and the Name of the County.



How do I get from this to a report/form/query showing the County Name and County Mileage?


Also, the column County Number in the first table is titled "County Code" in the second table. Does the title has to be the same?


Thanks again!

Edit: just to clarify, how do I define a relationship between tables? So far, I only know how to define relationship between columns.

[RuralGuy]

...the column County Number in the first table is titled "County Code" in the second table. Does the title has to be the same?

If the data are the same in each table then it is easier to understand and maintain if the names of the fields are the same in both tables but it is not manditory.

[KIDRoach]

Finally~! I got it to work!

I have another related question, however, now that I know how to do that.


So I have 3 tables now.

First table has 3 columns: County No., City No. and Total Length

Second Table has 2 columns: County No. and County Names

Third Table has 2 columns: City No. and City Names


I want to add two columns on the first table. County Names and City Names.

I tried using the method that you had. It didn't work. For some reason, when I put the county names in, it showed up okay.

But, when I tried putting the city names in the query, it doesn't show up. Is there another method?


Thanks!

Edit: Here's a screenshot of what I did.



Am I doing it right?

INC_Number = City No. = City Code
COUNTY_COD = County No.