bom

[krishnanhemanth]

hi everybody

i have a form with ...PRODUCT NAME, MODEL NAME, MODEL NUMBER, PRODUCT NUMBER.

I HAVE SUB FORM WITH....MODEL NUMBER, PART NUMBER, PART NAME, QTY REQD, QTY IN STOCK

IF A PRODUCT REQUIRES 10 COMPONENTS HOW DO I GET TO KNOW THAT FOR THE STOCK AVAILABLE HOW MANY PRODUCTS CAN BE MADE

PLZ HELP

 

[Galaxiom]

The possible make quantity would be the minimum value of a field created from the expression:
Int([QTY IN STOCK] / [QTY REQD])