>Edward,
>
>When you say:
>
>Basically, I would not join lookups here, i.e. I would retrieve data from one (master) table only, and use customized
> column.controlsources to show lookup fields.
>
>Does this mean that you make each lookup table a CONTROLSOURCE for a column?
>
>How do you get the relationship to where the foreign key code stored in your master table transalates to your description of your primary key in your lookup table?
>
>Michael Haggerty
>AMK Systems, Inc.
>amkhag@erols.com
No, lookup table is not controlsource. Actually, ColumnX.Controlsource=Thisform.GetcolumnX, where:
***Form.GetcolumnX method
if seek(mastertable.foreignkeyfield,"lookuptable","primarytag")=.t.
return lookuptable.descriptionfield
else
return "unknown"
endif
Surely, you can use generic method to work with many columns. This approach should be used selectively: it's especially efficient when volume of grid.recordsource and volume of lookup(s) are big enough.
Edward Pikman
Independent Consultant