>Hi Everyone!!
>
>I´m making an app, but I have trouble: In my form have diferent options like add products, delete, query, buys, etc.
>
>If I make a buy, the stock is automatically updated, e.g. Marlboro, stock 5, buying 10, then we have 15, ok?. When I try to chek by query option, the textbox still displays 5 in stock. I need to return to main menu and load again the form to get the right stock! I´m using refresh trying to fix it, but doesn´t work. Any idea??
>
>Thanks in advance...

Using a SQL select causes the alias to be opened again in a new workarea. As such, the buffered changes are not used in the query. You will need to TableUpdate() the alias in question before the updates will show up.

HTH.