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!

I finally figured it out on my own!

Yay!!!

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

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.