Hi all,

First, I'm not new to FoxPro in general having worked in Xbase (DbaseIII+ and FoxPro) just prior to VFP3. However, I've been away from it for a few years but am re-acquainting myself with the language (read Hertzenwerke's Fundamentals and Effective Techniques books). That said, my question:

In an application with a lot of lookups, do the lookup tables have to be in the DE? For instance, a form with one main table (view) in the DE to take advantage of the buffering and in the methods of the form (or controls) have SQL-Selects to query for lookup values? Is this a common practice for DeskTop\CS apps?

Thanks for the information

Robert