Run Multi Profiles on Single File?

[Dr. Evil]

Hello, not sure where to post this question. I have a couple different business. I would like to use a single fmp file to run all of these businesses. I do not want Company-A to be able to view Company-B records when logged in as Company-A.

Not sure how to set this up or even if it can be done.

Primary reason I wish to do this is...

I'm in the stages of building a complex project management db.

I'm using this db in "real-world", actually creating and reporting actual business records.

And at the moment I have one company on old solution, and another company on the new solution. As mentioned, Im still developing the new solution. So I don't want to create copy of db, migrate it all and... IF I make any modifications to db, then I will have to make mod twice. In both files! See my dilemma?

Make sense? Ask me for any clarification.

THANKS AS ALWAYS AMIGOS

[Vaughan]

This could be done using access privileges. It's a variation of limiting user A to see their own records, of which posts come up regularly in the Forums.

Basically you'd create a table containing users and user IDs, and a company id. Each record in the database would have to be associated with a company id (or if desired a user id to narrow the restrictions down further).

A privilege set would be created that restricts record view access to that of the company id of the logged-in user.

This will not completely hide another company's records from a user: they will be visible but the fields will display instead of displaying the data. By strictly controlling navigation and interface you can remove even these records from the user, but it's a lot of work.

There are arguments for splitting the database and having separate systems for each company...

[Dr. Evil]

Still a little in the dark...

I have the company and users table set up, tho I may need to make a mod or two to accommodate this technique. Can you explain how to set this privilege set up?

Also... I'm interested in these arguments. Can you point me in the direction of some reading material, other posts and what not?

Thank you!