Hi David

I thought I had understood or perhaps my posting was not clear and got the solution for a different problem.

I have built a framework complete with wizards/builders to simplify as much as possible its use. One of the builders allows to create "zoom" objects, that is, objects that deal with searching and lookups. Whether the object is based on tables or views makes no difference to the developer: just the click of a radio button. Once the object is created, usually a combobox, the builder allows to apply the new class to the data dictionary/dbc for use by other wizards.

My main customer is a company that produces financial software and all the regulatory aspects of it. The italian central bank issues a number of guidelines to, among other things, classify risks: this means that there is a very large number of lookup tables that are used almost everywhere. I find them in the procedures that deal with loans, leasings, factoring, mortages, etc. And by the very nature of the clients, the same application will have to run in native VFP tables and c/s.

What I thought would be easy is, to say the least, confusing me. All the forms used in the application have private datasessions. The number of combo boxes per form is very large. If I base the combo boxes on views the load times of the forms is unacceptably high. How can I make the combo object open its data sources on the default datasession and use them in the form private datasession?. This would allow for opening the lookup views only once, and for the most common of them this could be done at application start up and during wait states.

TIA

>>Just run a SELECT command against the table, it's smart enough to know if it's already open.

>How do I access tables opened in a different datasession? One of our apps has over 70 lookup tables, all used for comboboxes. I would like to open these tables only once in the application. We use only private datasessions in our forms. How do I access tables opened in the default datasession?