Access ELF Table/Field Source Window

The Table/Field Source selector window can be triggered from three distinct locations in the Access ELF program. It can be launched from the Source button of the Leixicon Lookup window, to identify the associated database field of a new word you're entering into the lexicon. It can be launched from the Source button on the Spelling window for the same reason (adding vocabulary during the spellcheck process). It can also be launched by clicking the Synchronize Lexicon button on the Advanced tab of Settings.

From the Lexicon or Spelling windows, you can choose either to manually or automatically update the lexicon. By "manually", we mean that you'll be entering information only for the term that appears in the word box of the Lex Lookup (or Spelling) window. In that case, this dialog gives you a way of selecting the table and field to associate with the new lexicon entry. Once selected, click Close. The selected database table and field will appear on the client window. Click Add Attribute (or "Add" on Spelling window) and the proper attributes will be added for this entry.

If you've added several entries to the database since the previous analysis and want to make sure that Access ELF understands references to these data terms, use the Synchronization buttons. Instead of pre-selecting data items to add, the Synchronization process will scan and synchronize the selected field, the entire source table, or the complete source MDB file.

If one or more of the terms is already in the lexicon, you'll also see a Data Synchronization Report window that shows you what's actually been done during the process.

This was a much-requested feature that will speed up the process of updating database interfaces. It's useful for those common situations in which data changes daily or even hourly. You'll no longer have to go through the tedious process of re-analyzing a database just because a few (or few dozen records) have been added. Of course, if the database structure (tables, fields and relationships) do change, you will need to rerun the Analysis to make sure that ELF is aware of the new structures.