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