>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
Robert,
They need not be in DE unless you refer them as controlsource in some control. Also instead of DE you could use form.load to open tables you need.
&& A readonly textbox to show description
form.SomeTextBox.Controlsource = 'myLookup.myField'
This needs myLookup either in DE or loaded from load event.
&& A combo using a lookup
this.Rowsourcetype = 3
this.Rowsource = 'select myDesc, myID from myLookup into cursor crsCombo'
This doesn't need lookup in DE nor loaded from load (SQL commands open them as necessary).
Cetin