Instead, we add a Quantity field to the Order Details table.įor Table Name, enter a descriptive title. We can’t add another row with 1012 and 30 because the Order ID and the Product ID combined make up our primary key, and primary keys must be unique. That means our Order Details entries look like this:Įlizabeth ordered one each of products 12 and 15, and five of product 30. In our scenario, Elizabeth Andersen’s order number 1012 consists of products 12, 15, and 30. You create a primary key for that table using the combined keys from the two tables. In the scenario described earlier, you create an Order Details table with records that contain, for each item in any given order, the ID from the Order table and the ID from the Products table.

This new table is called an intermediate table (or sometimes a linking or junction table). To create many-to-many relationships, you need to create a new table to connect the other two.

For those relationships, you simply connect the appropriate fields with a line. You create many-to-many relationships differently than you do one-to-one or one-to-many. One order may include one instance (or more than one instance) of a specific product and/or one instance (or more than one instance) of multiple products.įor example, customer Elizabeth Andersen’s order number 1012 might contain one each of products 12 and 15 and five of product 30. Your Products table contains the individual products you sell, which are part of many orders in the Order table.

Your Order table contains orders placed by multiple customers (who are listed in the Customers table), and a customer may place more than one order. They provide crucial information, such as which customers your salespeople have contacted and which products are in customer orders.Ī many-to-many relationship exists when one or more items in one table can have a relationship to one or more items in another table. Many-to-many relationships are the most commonly used table relationships. Try it! What’s a many-to-many relationship?

Filemaker pro 12 relationships