For example in a basic order-entry application.  There are Orders and OrderDetails. OrderDetails accepts entries of Inventory Items.  For example, an order may be of a specific "type".  This "type" typically includes 10 of the same Inventory items that meet a certain criteria according to "Class" or other field value.

So when this "type" of order is added (initiated), I want to programmatically add child records to the subform (and retain the appropriate relationship).  These new child records will consist of all Inventory form items that meet a certain criteria.  The criteria string used to fetch and insert depends on the Class in the parent record.

I would prefer this event to happen in the "on add" trigger of the Parent form, but really I don't care when it happens but I would like for it to happen without user thinking about it, but if it needs to be a "button press" in a subform, I guess that would be Ok.  (I come from an little iOS and lot of MS Access background, so I'm having difficulty understanding what is and is not possible in Zoho Creator)  But I do appreciate the cross-platform compatibility of Zoho.

This would greatly speed data entry.  The user can then go into the subform and edit Quantity and Price fields accordingly and be assured they did not forget to add a particular item.

Thanks in advance

Robert Keck

USA, Texas