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!