Easier to design all in one file. I understand the reason to seperate is because it makes it easier to update your application because you don't have to import your data. Not usually into four files but two. One file contains layouts and the other contains all the tables. You could have several files but there is no real reason, unless you were a big company that had teams working on different layouts. I perfer to just leave all in one file. Updates aren't that difficult when understand how filemaker works.
About planning a databaseA well-designed database promotes consistent data entry and retrieval, and reduces the existence of duplicate data among the database tables. Relational database tables work together to ensure that the correct data is available when you need it. It’s a good idea to plan a database on paper first.Follow these general steps to plan a database:
Relational Database Design 101 (part 1 of 3): Designing a Flat File Database
Relational Database Design 101 (part 2 of 3)
Relational Database Design 101 (part 3 of 3)
MY STANDARD LIST OF FILEMAKER LINKSThe White Paper for FMP Novices is useful -
Filemaker Free - Listing of free resources -
Free unlocked templates are useful for examining design
By Richard Carlton Consulting
Starting Point -
RCC Blog -
By yzysoft.com very clean and elegant Contacts | Products | Invoices | Letters
Sample Database -
A free calendar is available and can be integrated into your database
Seedcode Calendar Free -
Filemaker's Online Help Pages
FMP 12 http://www.filemaker.com/12help/index.html
FMP 11 http://www.filemaker.com/11help/index.html
FMP 9 http://www.filemaker.com/9help/index.html
Looking at FMP business database demos is useful - some are fully useable
The Excelisys Business Tracker V3.0 -
Filemaker released a FMP runtime database in 2007 for students called "Campus Productivity Kit" and is available online, notably at CNet
Google "Campus Productivity Kit" https://www.google.com/search?q="Campus+Productivity+Kit"
WIN - http://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577579.html/
Mac - http://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577567.html/
You can rename the database from a .usr file to a .fp7 file and open in FMP 7 thru 11
Lynda dot com has Filemaker Videos (portions are free)
YouTube - Filemaker Videos
UK FileMaker Channel
FileMaker, Inc. Channel
Lynda.com Channel - Filemaker videos
Dwayn Wright's Channel
Soliant Consulting Channel
Filemaker Academy Channel
Skeleton Key Channel
Accelerate Computer Training Channel
Scoop.it is an information curation site - I discovered it three days ago 8/8/2012.This is my scoop it site - http://scoop.it/t/filemaker-info
Another FMP Scoop.it site - http://www.scoop.it/t/fm-news
Filemaker Wikipedia -
Filemaker - Version By Version -
You can search specific Filemaker sites on this Custom Google Search
DEFINATELY all tables in one file.
I have helped people with old Filemaker files where every table was in a seperate file and I've never been in so much agony as then.
You can make as many tables in one file as you want. And you'll have no problems creating relationships between all of these tables etc.
Thanks for the help. Sounds like tables is definitely the way to go.