How do I create a relationship between two tables?

I’m using Five to create a database (in the tables interface). What’s the fastest way for me to create a one-to-many relationship between two tables?
I have one table called Suppliers. and one called Services. I want to have the two tables related, so that one supplier can have many services.

Hi ericky1k1,

Five’s Table Wizard makes it very fast for you to create a one-to-many relationship between tables as all you need to do is select the table to create the relationship with and Five will handle creating the Foreign Key field and index.

Below is a short video to show you how to create the relationship between your Suppliers and Services tables.

Steps to Create a One-to-Many Relationship Between Two Tables

  1. Select Tables in the menu.

  2. Click the New Table Wizard button in the form app bar.

  3. Type Suppliers in the Name field.

  4. Click the Add Fields button.

  5. Add the required fields and their definitions.

  6. Click the Save button in the Table Wizard app bar.

  7. Click the New Table Wizard button in the form app bar.

  8. Type Services in the Name field.

  9. Click the Add Fields button.

  10. Add the required fields and their definitions.

  11. Click the Next button.

  12. Click the Add Relationships button.

  13. Click the lookup icon in the Table field and select Suppliers.

  14. Click the Save button in the Table Wizard app bar.