Customer >--< Invoices many customers can have many invoices
Customer >-- InvoiceLine --< Invoices An Invoice Line has one Customer and one Invoice - it is called a join table.
Join Table Site:forums.filemaker.com https://www.google.com/search?q=join+table+site%3Aforums.filemaker.com
You might look at the yzysoft.com sample database listed below.
Home > Designing and creating databases > Creating a database > About planning a database
A 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 LINKS
The White Paper for FMP Novices is useful -
Filemaker Free - Listing of free resources -
Free unlocked templates
By Richard Carlton Consulting
Starting Point -
RCC Blog -
By yzysoft.com Contacts | Products | Invoices | Letters
Sample Database -
Try the core 3 invoices demo. Don't have link but google it. I actually bought full version in the end and adapted it as I was getting bogged down with the payments part...