Dynamic stock field

[Sergio]

How to create a dynamic stock field in a products form which value depends on buys and sales.

In fact I have a query who calculate the existing stocks for each product, but I don't know how to carry this value to the stock field in the products form.

 

[glynch]

If you a query that does that, you can use that same query to populate a combo box to select the product, using product name as the visible field. Then next to it you can put a text box with a datasource of:

ProductCombo.column(2)

This would work if the amount in stock field was the third one in the query, the column property is zero-based.

 

[Sergio]

Tks for your advice and for your original logic point of view.

I going to try these solutions.

See you!