Relationship between forms

Relationship between forms

A relationship in your Zoho Creator application refers to the link that is created between the data in different forms so that you can achieve a certain level of co-ordination, leading your data to interact with each other. This relationship brings all the information together in a meaningful manner, facilitating a streamlined process when it comes to capturing and updating information.

Types of relationships

There are three types of relationships:

  • One-to-one
  • One-to-many
  • Many-to-Many


This is a simple and direct relationship where one value can be associated with only one unique value. Let's assume you have a Library Catalog with a form for Book Name and a Form for Book ID. Each book will have a unique ID. So, in the form for Book name, drag a lookup field that fetches the unique ID from the form Book ID with single selection as its display format.This will allow one to select the same Book ID for different book names. To establish a strict one to one relationship, make use of the bidirectional property, which will add a lookup field that fetches the data of book names with Single selection as its display type in Book ID form. By doing so, Book Name will be linked to one Book ID. This is a one-to-one relationship.


One-to-many or many-to-one is a common kind of relationship where one value can be mapped to multiple values. For instance, you have an Hospital Management app. The app has an In-patient form and a Doctor form. Here, the mapping between patients and doctor will be one-to-many and many-to-one. So, in the form of In-patient, drag a lookup field that fetches the doctors name from the Doctor form with multi selection as its display format. One doctor can attend to multiple patients and multiple patients can consult with one doctor.

Note: Subform can also be used to create one-to-many relationships.


Many-to-many relationship is when multiple values can be associated with multiple values. Let's assume you have a recruitment application for your organization. In the have you have a candidate details, interviewer details, and Interview schedules. In this case, one candidate can be interviewed by multiple interviewers and one interviewer can interview multiple candidates.So the mapping between candidate and interviewer is many-to-many.

Related Topics

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: