Nico,

> I have a form for entering materials, machine operations, etc, ect. For

a

> certain material there is a description, for a operation there is a
> description. Now, when I open the main query, I set the Keylinks /
> Keysource properties of the material, operation lookuptables, so the data

is

> displayed. So I have a few queries open on that form (1 main query and 8
> lookup queries). Should I do it like this, or should I retrieve all my
> lookup data for that one specific record through a stored procedure and

put

> those 8 selects in one procedure ? And put the call to the stored
> procedure in a after scroll event of the dataset ?
>
> Any idea ?

I would advice use lookup tables. I have many forms with lookup tables and
there is no problem in use it.

Luiz.