Flowfield with parameter

ferris

I have this problem.
In a table there are 3 columns:
1) Type (option: type1/type2)
2) Code (validate in 2 different tables, depending from type)
3) Description (lookup Flowfield)

I want to calculate the decription in table1 or table2 depending from type value but in the properties is possible to insert only one CalcFormula for each flowfield.

Thanks very much.

David_Cox

You cannot have a conditional Flow field like you want, make the description a normal field then do a conditional on Validate for your Option field and Code field case statement.

The sales line does this based on "Type", when you enter the "No.", look for the code there.

Remember if the User changes the type to clear out both Code and Description fields as well

David