October 1997
Intermediate to advanced
1312 pages
38h 56m
English
Access 97's Table Analyzer Wizard detects cells containing repeated data in table columns and proposes to create two new related tables to eliminate the repetition. This wizard uses Access 97's Lookup Wizard, described in Chapter 10, "Creating Multitable and Crosstab Queries," to create the relationship between the two new tables. After the wizard creates the new related tables, tblNewName and tlkpLookup, your original table is renamed to TableName_OLD, and the wizard creates a one-to-many INNER JOIN query named TableName to return a result set that duplicates Datasheet view of the original table. Thus, you need not change the references to TableName in your Access application objects.
◂◂ See "Using Lookup ...
Read now
Unlock full access