Determine the fields each table will need.Įach table has only one subject, and all fields in a table describe only that subject.

a product may appear on many line items.

To solve the problem in this example, add the intermediate table Line Items to store information about products sold.Īfter resolving the many-to-many relationship, this example shows: You must resolve the many-to-many relationship by using an intermediate table, which breaks the many-to-many relationship into two one-to-many relationships. Relational databases handle one-to-one and one-to-many relationships directly. You cannot set up a many-to-many relationship directly between two tables.

Note that there is a many-to-many relationship between Invoices and Products.

In a many-to-many relationship, many records in Table A match many records in Table B.

In a one-to-many relationship, one record in Table A matches many records in Table B.

In a one-to-one relationship, one record in Table A matches one record in Table B.

Indicate the type of relationship between tables by connecting them with a representative symbol.

In this example, an Employees table doesn’t fit into this relational database. If a table has no relationship to another, it’s probably unnecessary.

For example, customers can have invoices and invoices can have products. Connect one table to another to indicate a relationship between them.You can do this by writing simple sentences that describe how the categories interact, such as 'customers order products' and 'invoices track customers’ orders.' Determine how the tables are related to each other.These categories will be tables in FileMaker Pro.įor example, a Sales database might include these tables: Customers, which includes customer information Invoices, which includes order information and Products, which includes product information.

Determine the categories of information that your relational database will need.In database terms, the plan that you develop is called an entity relationship diagram.įor the general steps for designing a FileMaker Pro custom app, see Creating a custom app. Before you create a relational database using the relationships graph, design your database on paper or onscreen.

Filemaker pro database examples