Building Many Books that can contain some of many Paragraphs
Books Table >-- Contents List --< Paragraphs
Book ID 001 - Content 001 (Book 001 | Paragragh 003)
Many Students take Many Classes
Students >-- Attendance (one student | one class) --< Classes
Many Invoices can have many Products
Invoices >-- InvoiceLine (one invoice | one product) --< Products
Join Tables - About http://filemakerweetbix.wordpress.com/2009/06/12/join-my-table-part-one/
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)
The White Paper for FMP Novices is useful -
Key Concepts in Filemaker 7 (PDF)
In terms of the tables you have described, do it this way:
Routes::__pkRouteID = Route_Waypoint::_fkRouteID
Waypoints::__PkWayPointID = Route_Waypoint::_fkWayPointID
Then a portal to Route_Waypoint on a Routes layout can be used to list all waypoints for that route. Fields from Waypoints can be included in that portal to display additional details about that waypoint and fields defined in Route_Waypoint can be used to record information (such as the sequence) specific to that pairing of Route and Waypoint records.
In addition, a portal to Route_Waypoint on a Waypoints layout will list all Routes that include that waypoint.
Thanks David & Phil,
Two very good solutions to my problem. I would say that an invoice solution as mentioned by David would all the same types of features that I am looking for. I will now play around with the method described by Phil and hopefully from the two suggestions, I will achieve the desired results. Many thanks to both of you.
It's the same solution with different names.