Jump to content

Many databases in runtime


This topic is 5787 days old. Please don't post here. Open a new topic instead.

Recommended Posts


I need solution to manage more companies in one database.

For example:

I have 10 companies in database and each company have own employees and doing some statistics on employee data.

I want to choose a company with which I want to work in that moment. So if I choose company no.4 I want to see only employees for that company.

One solution would be export/import data for each company created. I would create script ( when you want to create new company to work with ) to export existing data in company#.fm7 file and empty out the database. And when I will change company I would first export existing data to company#.fp7 and import data from choosen company#.fp7 file.

Is there better way to do this?

P.S. I need this also for network solution ( many users working on same database on different companies ), but in this moment it seems impossible ...

Thanks in advance

Link to comment
Share on other sites


Why not view separate companies in a portal?

Make a global field g_company and a self-join between that field and your companyID field. The portal onto the company data will then only show values currently related to the value in g_company. You can populate the g_company field with a value list made up of all the values in your companyID field so enabling you to switch companies easily. This would work in a networked environmnet and you could restrict access by pre-setting g_company

apologies if I've missed the point.

Link to comment
Share on other sites

I am looking for a system which will separate found sets based on company.

I would like to make selection on top menu and choose company that I like to work with and database will show and allow user to work with data that is based only for that company.

So if I work with chosen company I would like to see only this company employees, invoices, products, ..., perform find on this records, add records, ...

Link to comment
Share on other sites

Basicly is it done by using a proper normalized structure and GTRR (go to related record) sometimes with the "Found set" feature and:


Before fm8 were we forced into schemes like:



Link to comment
Share on other sites

I know that but I don't want to load so much extra work to myself. If I would do this It means that I would have to include GoTo Related Record in each script that is showing data based on company. And there is also problem with found sets ( omitting, showing omitted, ... ).

I was thinking about creating another database ( saved as clone ) for each company. Scripts stays the same and you have empty database to work with. I would create some navigation menu to choose with which company I would like to work. But here is problem in runtime ( you can't create another file and have it open ).

Any ideas?

Link to comment
Share on other sites

This topic is 5787 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.