Subject | How to avoid many Query of the same table? |
---|---|
Author | Michael Fung <ibo@cmsweb.com> |
Post date | 2002-12-13T09:28:24Z |
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?
Thanks,
Michael
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?
Thanks,
Michael