>I have a combo-based class that has the SQL in the init of the class. There's a custom property of the class that tells the name of the table to get the data from.
>
>This class worked fine in Tripsoft. Now I'm using it in a new app, and it tells me it can't find the table.
>
>The table is in the database, which is open and the current database. The table, as well as the database, is in the path.
>
>I don't have the table in the DE because there are a _lot_ of look-up tables and I'd rather just have the select open it up. I have no idea why it can't find it.
>
>Any ideas?
>
>Thanks,
>
>-Michelle

Michelle- I read the whole thread and saw that you solved the problem, but thought I might offe rsome insight as to what probably happened:

Since you are using a Private Datasession in your form, the database being opened in the defualt or calling form's datasession has no effect. So as soon as your form instanciated, the new datasession went into effect and no database was open. Even if you opened the database in the form.init, it was not open in the the control's init event because the form instanciates from the inside out: control.init runs before form.init. SO to have the database open in the new DS, oyu would either have to open the DB in the Form.Load, or the DE.BeforeOpenTables event, or have member tables present in the DE. I'll guess that you had none of the above?