I have a Main form called "New Order" and a subform called "Material Order" field name is also called Material Order (Link name SUB_Material_Order).
Material Order Main Form has following:
Type - Which is autopopulated in deluge so users know what "Type of Material to put in that Line.
Manufacturer - Lookup field of "Add_Manufacturer"
Brand - Lookup field of "Add_Product" field Brand
The rest of fields are auto populated based on Brand choice Lookup field
I have the subform (Material order) already have 8 Line items with the Populated Type inputed in.
But, I would also like it to default the Brand choice with our popular orders and our users can change when necessary.
Example below of what it pops up
And what I would like to have when opening form
I'm not sure what i'm doing wrong with this portion at all. Hoping y'all can help. Thank you.