D
David McKnight
I have a form [part builder] containing a subform [part_bom]. In the sub
form I need to have a field (column) that does a calculation based on data in
the form. The Sub form uses two tables [part ID] and [layer ID]. In the table
[layer ID] I would like to store the formula for each record set, so that the
formula would change depending on which layer ID was selected.
LayerID table design
[ID] [Description] [Slitwidth Formula]
1 Outer layer +3.14*[OD Inches]*[Cut Height]
2 Tie 1 Sin[wind angle] * [Cut
Height]
vales for [Wind angle], [cut hieght] & [OD inches] would be input in the form.
My question(s) - Is there any way to do this?
What format do I make the [slitwidth formula] field, ie, Text? Do I maybe
reference a module?
ID+3.14*[OD Inches]*[Cut Height]
form I need to have a field (column) that does a calculation based on data in
the form. The Sub form uses two tables [part ID] and [layer ID]. In the table
[layer ID] I would like to store the formula for each record set, so that the
formula would change depending on which layer ID was selected.
LayerID table design
[ID] [Description] [Slitwidth Formula]
1 Outer layer +3.14*[OD Inches]*[Cut Height]
2 Tie 1 Sin[wind angle] * [Cut
Height]
vales for [Wind angle], [cut hieght] & [OD inches] would be input in the form.
My question(s) - Is there any way to do this?
What format do I make the [slitwidth formula] field, ie, Text? Do I maybe
reference a module?
ID+3.14*[OD Inches]*[Cut Height]