Calculate field from flowfields

jorgito

Hi all.

I have the following question.

In a table called Header I have 2 flowfields: Initial Quantity and Consumed Quantity that are calculated from other tables. I want to create a field called Remaining Quantity that is "Initial Quantity - Consumed Quantity" and is calculated as the flowfields are calulated.

How should I do it?

Jorgito

ara3n

You can't add a new field. but you can add a text box and set sourceexp to
"Initial Quantity" - "Consumed Quantity";

jorgito

The problem is that I want to be able to filter on Remaining Quantity, both using the Field Filter of the form and using the SETFILTER in code.

Any ideas?
Jorgito

ara3n

add the original fields on the form. The user have to filter on them separately.

jorgito

So, how will the user be able to show only the records that have a Remaining Quantity less than 10 (<10) ??

ara3n

Add text box called Rem. Qty filter. and a button called calculate.

Onpush of the calculate loop throu the records and mark the records that meed the criteria.