Reindexing a Train Wreck

[Ketcham488]

I saved a train wreck of a database (RE7) for a nonprofit. I have normalized all data in two tables and had to re indexed the primary table due to crappy design. My question is: After I re index the primary table how do I get the secondary table to align itself with the new indexing? Any help will help

 

[John Big Booty]

You will need to use an Update Query. But you will need some way of linking the data in the two tables for this to work properly.