make an Index table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a badly disorganized table, I am trying to make a couple of index
tables to make my way easier around them....

I have a main table which has info about people.... one record per person....
the record includes a field which has a number, which corresponds to an area
in the county. However there is a another field which has another number
which corresponds to an ID for a name of a specific neighborhood, which is
sometimes bigger (territorial wise), so the problem is, I end up with a
neighborhood which contains, two or three county sections...
I need to make an Index table of sorts, which would give me which county
numbers corresponds to which neighborhood number....

any ideas??
 
I have a badly disorganized table, I am trying to make a couple of index
tables to make my way easier around them....

I have a main table which has info about people.... one record per person....
the record includes a field which has a number, which corresponds to an area
in the county. However there is a another field which has another number
which corresponds to an ID for a name of a specific neighborhood, which is
sometimes bigger (territorial wise), so the problem is, I end up with a
neighborhood which contains, two or three county sections...
I need to make an Index table of sorts, which would give me which county
numbers corresponds to which neighborhood number....

any ideas??
Click to expand...

well, it sounds like you've designed the table: two fields,
CountyNumber and NeighborhoodNumber, joint two-field Primary Key.

Perhaps I don't understand your question!

John W. Vinson[MVP]
 
well, it sounds like you've designed the table: two fields,
CountyNumber and NeighborhoodNumber, joint two-field Primary Key.

Perhaps I don't understand your question!

John W. Vinson[MVP]
Click to expand...

I wish to extract from my disorganized table the info... since there are 455
CountyArea Numbers and 255 Neighborhood numbers.... I dont know how to
extract that info from my main table...
 
I wish to extract from my disorganized table the info... since there are 455
CountyArea Numbers and 255 Neighborhood numbers.... I dont know how to
extract that info from my main table...
Click to expand...

Try creating a MakeTable query based on your table. Select these two
fields, and nothing else. View the query's Properties and set the
"Unique Values" property to True so it will show only one instance of
each CountyArea and Neighborhood pair. Change the query to a MakeTable
query and run it using the ! icon; this will at least extract all of
the pairs (which might be right or might not!!) currently in your
database.

John W. Vinson[MVP]
 
Back
Top