Skip to Content
Former Member
Jan 09, 2014 at 10:18 AM

Need Formatted Search Query


Dear Expert,

I want to call value to the quantity field in BOM from two different forms

i.e suppose i selected first item in BOM and that item is from MATERIAL PLAN then the

quantity field will be copied from 1st form & when i select another item belongs from GLUE PLAN

then the quantity should be copied from second form.

I attached two form for your reference:

1st form table name : @SIN_MPLAN & field name SQM_Total

2nd fom table name : @SIN_GLUE & field name GLUE_Total

NOTE: Common Field on both Form are Project_Code & Material_Code