Hi to averybody,

First at all I am new with remote data (SQL) and I trying to develope a sales/inventory application.

I need some suggestions.

- My Dataenvironment has 3 remote views: v_invoice, v_lineitems, v_inventory
- All views are set with: NoDataOnload = .T., BufferModeOverride = 5

The form function very well but the question is:

How can I discount the stock of each inventory item when I am finishing the invoice ?

- take advantage of SQL begin transaction and commit.
- How will be the code ?
- ??????

Can you give me any guide or suggestion Please ?

Thanks in Advance

Amilcar Pino