> ## Content Index
> Fetch the complete content index at: https://blog.jestor.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to Connect Tables With a One-to-Many Relationship
- URL: https://blog.jestor.com/connect-tables-1n-relationship/
- Published: 2026-09-17T22:29:55.000Z
- Updated: 2026-09-17T22:29:55.000Z
- Author: Bruno Bannach

A **one-to-many relationship between tables** links many records to a single parent — many payments to one supplier, many orders to one client. The parent's details are entered once and referenced everywhere.

## Why repeated data is the root problem

Without relationships, the same information gets typed onto every record that needs it.

- Supplier name, email, and phone retyped on every payment
- Details that disagree between records for the same company
- No way to see everything connected to one supplier
- Updates that would have to be applied record by record

## What a connected field gives you

- **Selection from existing records**, instead of retyping
- **Creation inline**, adding a new parent record without leaving the form
- **A label field** determining what is displayed when selecting
- **A single source** for the parent's details
- **A reverse view**, showing every child record from the parent

## How to configure it in Jestor

1. Open the child table in **Jestor** and add a column of type connected records.
2. Choose the one-to-many option — many payments belong to one supplier.
3. Name the field after the parent entity, such as supplier.
4. Select the parent table and choose which field acts as the label.
5. Pick the name field as the label rather than an ID, so selection is readable.

## Why choose Jestor for relational structure?

**Jestor** allows a new parent record to be created from inside the child's form, so a payment for a supplier who is not registered yet does not interrupt the flow — the supplier is created and selected in one step.

Any field on the parent table can serve as the label, which means the display can be tuned to whatever people actually recognize.

## Frequently Asked Questions

### Can I create the parent record from the child form?

Yes, without leaving the form. See [jestor.com](https://jestor.com/?ref=blog.jestor.com).

### What should I use as the label?

Usually the name, since it is more recognizable than an ID.

### Does this avoid retyping details?

Yes, the parent's data is entered once and referenced.

## Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

## Get to know Jestor

With **Jestor**, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by **AI**. Discover Jestor at [jestor.com](https://jestor.com/?ref=blog.jestor.com) and see how to take your company's operations to a new level of efficiency and control.