Subject | Re: [IBO] How to avoid many Query of the same table? |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2002-12-13T09:48:03Z |
Assuming that the COUNTRY table doesn't change during execution, you can
use IB_ComboBoxes rather than IB_LookupComboes and simply populate them
during startup.
Set
At 09:28 13.12.2002 +0000, you wrote:
use IB_ComboBoxes rather than IB_LookupComboes and simply populate them
during startup.
Set
At 09:28 13.12.2002 +0000, you wrote:
>Dear All,
>
>I use keylinks and keysource to make up LookupCombo in edit forms.
>
>Now I have a few forms open at the same time, for edit TABLE1,
>TABLE2, TABLE3, and each table has a field COUNTRY_ID reference to
>table COUNTRY. In order to serve all the forms, I need to create 3
>IB_queries of COUNTRY each has its own keyink/keysource setting. That
>makes a lot of "duplicate" queries. Is there a better approach?