Improvements in the Lookup Column Feature

We are rolling out a few enhancements to the lookup column feature to further enhance its usability. 

Specify data type for  look up column:  Users can now change the datatype of the lookup column. Until now, the child column will share the data type of the parent column. With this update, you can set a specific data type for the child column. You can change the data type of the lookup column using the  Edit Design  option in the table.

Support for Default and Mandatory Values:  You can now specify Default and Mandatory values for a lookup column. You can do this using the  Edit Design option in the table.

Lookup column over a looked up column:  You can now make a looked up column (in the parent table) to also be a lookup column referring to another table (grandparent). This feature was not supported until now.

Behavior  change - Action on deleting values in a lookup column:  From now on when you create a lookup column, by default no action will be taken on the child column upon deleting the values in the corresponding parent column. 

Until now Zoho Reports provided options to delete the values in the child column when you delete the values in the corresponding parent column. This option has been removed with this update as it was found to be less frequently used and had high-performance overhead. 

For users who have already been using this option, we will continue to support it. However, we would like to emphasize that  "Delete the corresponding values in the child column"  option will not be supported for the new lookup columns that you create henceforth.