Hi Peter
Thanks for your response.
>Don't know FireBird, but am assuming you can create views.
Yes the app will be in VFP and I can use remote views. Or do you want me to create views in FireBird. Haven't done it but it is possible to.
>If it's reporting only,
Nay I am also supposed to maintain the master tables common, esp. the Items Master as it will have a Bill-Of-Material attached to the items. BOM once created is suppose to be used in all, incl. the parent company. So any changes to the BOM will reflect in the all the companies.
>* The obvious drawback being that, when your client buys a new company you have to add it to your views
>* But with decent indexing, depending on the size of your DB's, this could work.
Okay.
>If you have a unique identifier for the various subsidiaries, you could load all your subsidiaries into one new DB, and if you don't, you could still use this approach and create one during load.
I was thinking of putting all of them together in one sinlge database identifying from which company the data came from. But what fears me is the size of data between all of the companies may become big and then may raise issue in speed.