Create and use a Relational Database in Zoho Creator
I understood that Zoho Creator support full relational database function by linking forms through look-up field.
Is it possible to create in Zoho Creator an application which should obey below relationships diagram?
Desired relational database should have these types of relationship:
- 1 to 1 relationship
- 1 to (0 or 1) relationship
- 1 to many relationship
- 1 to (0 or many) relationship
Should I create a table for each entity (from A to V) ? Because relationship between A and C, D, E is 1 to 1. Should I have separated tables for these entities?
Is it possible to create a Combined html View which can see a record from A entity with all subordinate entities (from B to V)?
Is it possible to have one (or few if I wish) stateless form to enter the data in all tables ?
Are there any limitations in Zoho Creator for creating such an application?
Thank you for any help.
Is it possible to create in Zoho Creator an application which should obey below relationships diagram?
Desired relational database should have these types of relationship:
- 1 to 1 relationship
- 1 to (0 or 1) relationship
- 1 to many relationship
- 1 to (0 or many) relationship
Should I create a table for each entity (from A to V) ? Because relationship between A and C, D, E is 1 to 1. Should I have separated tables for these entities?
Is it possible to create a Combined html View which can see a record from A entity with all subordinate entities (from B to V)?
Is it possible to have one (or few if I wish) stateless form to enter the data in all tables ?
Are there any limitations in Zoho Creator for creating such an application?
Thank you for any help.