Hi all,

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 ?

Thanks in advance,

Nico Callewaert