>No, I hate multiple DBC-based solutions. I do have extra field in each table that relates to which company the data belongs though. I don't know, right now I'm checking out the use of CursorAdapter feature in 8 I just found out from Evan. Thanks Fred.
>
>>>The way old SBT handles multiple companies is to create same duplicate tables in different directory/folder. Thus, I have to enable switching to different company within the app.
>>>
>>>Wouldn't this create some sort of havec with the views created from these free tables that can change table locations?
>>>
>>>>You can create views of free tables, only the views have to be part of a DBC.
>>
>>You could have a different DBC for each company. That's the way I've seen it done. You do have each company in it's own folder, don't you? Even if you don't, as long as your DBC is named like SBT does with a 2 digit number at the end, that's all it would take.

Another option is to create a temp dbc, using CREATE DATABASE, and create the views on the fly for the company you want useing the CREATE SQL VIEW command. Then you could blow away the views and database each time. Might make your application slower depending on how many views you create.