Newbies databased Posted July 20, 2010 Newbies Posted July 20, 2010 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!
Newbies databased Posted July 20, 2010 Author Newbies Posted July 20, 2010 I finally figured it out on my own! Yay!!!
wireshop Posted July 20, 2010 Posted July 20, 2010 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
Isaiah 40:31 Posted July 31, 2010 Posted July 31, 2010 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now