You can pull multiple files together into a single multi-table file, but it's a bit of work to do.
Import Records can be used with a new table option to pull a table and it's data into a different file.
Scripts can be imported from one file to another.
You can select all the layout objects on a layout and copy/paste them into a layout in the multi-table file.
You can't import or copy/paste relationships nor can you copy paste value list definitions. (But you can copy and paste a list of custom values.)
You have to do it in the right order and paste carefully or references to scripts and fields in the original file will be broken in the new file until you find and reconnect them.
One trick is to copy and paste layout objects twice:
- Set up a layout to your newly imported table and make sure that the table occurrence listed in Show Records From in Layout Setup... is exactly the same as that in the layout from which you are copying. (YOu can change the name later if you need to.)
- Copy and paste the layout objects, but don't bother trying to adjust the location and size of layout part just yet.
- Import the scripts for this layout. (any objects on the layout that the scripts refer to are present so they won't be broken).
- Delete all the pasted layout objects and paste them again into the layout. (Now any buttons that refer to a script you have just imported will work.)
FileMaker Advanced's Database Design Report can also help you look for and fix such issues.
I haven't used it myself, but there's a third party tool named FMMigrator that is supposed to make this process easier.
Hi Phil. Thanks for the reply.
I took a stab at it, and it's going to be some work. Time to talk to the client. FMP should have been this way since the beginning. What would have been nice is to be able to drag layouts in the "Manage Layouts" window over to the new db somehow. Ah, but I am wishing, and this is FileMakerLand. Heh.
I have started copying all of my custom value lists into a text file so I have a library of those to copy and past as needed. It can also be easier to edit them in a word processor sometimes.
Really do wish there was a layout import option sometimes though.
how I copy a custom value list from file 1 to file 2.
- Open the Value list in Manage | Value list in file 1.
- Copy the name of the value list and paste it into the list of custom values.
- Select and copy list of custom values and the value list name.
- Exit Manage | Value lists by clicking cancel so that the value list isn't changed.
- Now you can paste the value list name and values into the custom values box in File 2, then cut/paste the value list name from the list of values up into the name box for the value list.