Auto Populate Fields On Sub-Forms
I when data is entered into one single select field in a sub-form, I need the value for the other fields in that record automatically populated. For example, if the Main/Parent Form is the "Order Form" and the Sub-form/Child Form is the "Products Form", when the user selects the product name in the "Product Name" field in the Subform, I need the application to automatically populate the other fields, such as "Product ID", "Price", "Product Description"- fetching this data from the "Child Form/Products Form". How do I accomplish this?