How can I create a relationship between two forms in Zoho Creator?
You can create one-to-one or one-to-many relationship between forms in the same application or different applications. To create a relationship between Form A and Form B, you have to add a Lookup field in Form B, imported from Form A. Example: Let us take the example of an “Employee Details” application. In this application, a form named “Employee” is created to add each employee record. Now, we also need to add the department details to which each employee belongs to. To do this, we will create a new form named “Department” to enter the department details in the organization. To create a relationship between the Employee form and the Department form, we will add the Department Name from the Department Form as a lookup field in the Employee Form. Refer the screen-shot below: Now you can access the values in the Department form from the Employee form. Thus a one-to-one relationship is established between the Employee form and Department form. You can also create one-to-many relationship
