We used to use older versions of filemaker, but once the multiple table feature was released we brought the extra filemaker files into one filemaker file by importing the data into a new table, then carefully chaning the relations.
Go to file, manage database
click the tables tab
create a new table with the exact same structure as the file you want to import
import the data from the file into the table
create a layout to display the new table data
text the data extensively to ensure everything is there
re-create your external file relationships with new table relationships.
Is there any automated way to do this? I have some extensive files I'd like to join but doing it by hand would take far too long.
By going to file,
choose the filemaker file to import
select new table from the Taget: drop down box
filemaker should create the fields for you automatically
you will then need to re-create any auto enter calculations, validation rules etc etc
make sure you test, test and test for peace of mind!