Lookup fields are a great part of Zoho Creator. They ensure that common data is only entered once, avoiding spelling mistakes. Crucially a look-up also relates data from one form to data in another.
Often though you will want to have the contents of one look-up field be determined by the value of another field, even another look-up field. This is where those new to Zoho often get stuck. It is one of the commonest questions asked on the Zoho forums.
So lets have a look at a scenario. In my App called 'Blog App' I have a few forms and corresponding views. Departments, Employees and the important one, Job Detail.
The Departments form simply provides a way to add new dapartments and provide a description if you want. See Fig 1.
Often though you will want to have the contents of one look-up field be determined by the value of another field, even another look-up field. This is where those new to Zoho often get stuck. It is one of the commonest questions asked on the Zoho forums.
So lets have a look at a scenario. In my App called 'Blog App' I have a few forms and corresponding views. Departments, Employees and the important one, Job Detail.
The Departments form simply provides a way to add new dapartments and provide a description if you want. See Fig 1.