Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

I'm relatively new to FMP. Last year I modified the Business Productivity Pack to meet our company's basic needs. We recently paying a hosting company to serve our database off site so we can use it in multiple countries and access it simultaneously.

The hosting company charges us based on the number of .fp7 files we use. I removed the unnecessary ones. Now we are down to just 2 (Sales_Orders and Inventory).

I would like to combine them so all the necessary data entry tables and relationships work in one .fm7 file in order to cut our monthly bill from the hosting service in half.

Any tips on how to make this fairly simple task?

Thanks!

Posted

FMPro Advanced lets you copy and paste tables from the "manage database" dialog. I would copy all the tables you need into the file that you want and then import everything into these new tables. Of course you would have to rebuild all the relationships

  • 2 weeks later...
Posted

To elaborate on Wireshop (I just figured this out myself).

You go to Manage Databases,

click on the "Fields" tab,

and then select all the fields you want to put into your other database.

Click copy.

Go to the database file you want the copied fields to be pasted to.

Again go to the Manage Databases ---> Fields tab.

Click Paste.

It did something funky like not copying all the fields the first time for me. But when I tried it again it worked, so I don't know what I did wrong the first time.

Anyway, hope that helps.

This topic is 5227 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.