make an Index table

[Alex]

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??

 

[John Vinson]

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??

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]

 

[Alex]

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]

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...

 

[John Vinson]

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...

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]