Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Design database for multi-company
Message
 
 
To
05/01/2001 22:33:49
Sanit Kiriwong
I.S.A.Solution Co.,Ltd
Bangkok, Thailand
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00460150
Message ID:
00460375
Views:
14
I would first ask a clarifying question. Do you mean an application that will be used by multiple companies accessing their own data? Or do you intend for the application to be used by some corporation that will be maintianing data for multiple companies?

If you intend this for multiple companies accessing their own data, I would have different data sets [individual schema for each company]. The exception would be if a compilation of data of the multiple companies is also needed for reporting purposes. Then I would have one data set like Barbara suggested.

Also, how important is security of data between companies?

>Hi all,
> I am going to develop an applicaction use SQL SERVER Backend that was intended to bemulti-company or with different data sets,How do I better way?
>
>1. Design a company ID field in the table of the database and then filter on all
>transactions based on that ID ?
>2.Can DQL SERVER separate location collectd data for eacs company?
>3. I will like that experienced people give me advise about it. Has anyone
>worked with this ?
>
>Thanksin advance,
>Regards
>
>Sanit kiriwong.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform