Having tested Zoho Creator functionality for several times already I am still expecting to implement my next task from the first shot, because I do believe this product is capable of resolving such issues.
This time it’s checking master detail form function on the same example as I did before testing product Invoice (master) and it’s Items (details). I easily created the app and 2 tables (Invoice and Items).
This is how the Invoice looks like:
I managed even to merge these 2 tables using Lookup Field and added Formula Field, what enabled the calculation of Total item.
This is where we are done with the good news. Unfortunately Zoho Creator doesn’t have any mechanisms for master detail support and offers to use Deluge Scripting, if the steps of its implementaion is of any interest for you can take a look at this.
The thing is it's not worth taking so much pains and above mentioned steps in order just to get 2 links, which don't solve the given task well.
I also couldn’t find out how to calculate Grand Total of all Items in the invoice. I suspect, it also requires Deluge Scripting.