Subject Re: [IBO] query / lookup data question
Author Luiz Alves

> I have a form for entering materials, machine operations, etc, ect. For
> 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
> 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
> 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.