I have an Inventory form where I store all my part info.
I need to adjust a field to automatically calculate when a certain Manufacturer is selected from the drop down field.
I was thinking about a Fetch Records to do this.
example;
Inventory Form
Manufacturer Drop-down field
three pricing fields (A, B, C)
If Manufacturer(Big Int field) ="Apple"
Calculate Price in "A" times.3 and place amount in Currency field "C"
aep=(Inventory[ID=Input.manufacturer].count()>0)
if Input.Manufacturer.toString()=="Apple"
{
field c= a*.3
}
would this be correct.
I think I am missing something.