I have am working on an order tracking app. This is for tracking orders for items which require custom production (not just items off the shelf). I have an Orders form, which generates an order ID for each entry, and within it a sub-form for Items. As each one of these is a custom job within the order, I have been trying to import the order ID from the parent form into the subform, but if I do a standard lookup, it makes a dropdown of all the IDs in the Orders table. Is there any way to automatically have the subform entry pick up a field from its parent entry?

This example made me think there was, but as I said, when I try and follow it, I end up with a list of all the values to pick from, rather than just the value of the parent

http://www.zoho.com/creator/help/forms/creating-subforms.html#Creating_relationship_between_mainform_and_subform

Does that make sense?

Thanks!