Inserting Values to a table according to a control from another form/query

V

Veli Izzet

Hi all,

I want to insert some data to a table according to a YES/NO control in a
form.

The problem is that, the Query of the form DOESNOT contain the table I
want to update.

The query is based on customers & sales, the table is based on customers
and their running accounts.

If the sale is Final (Yes/No field in Sales), I want the running
accounts of the customer to be debited.

In English:

If the filed "Final" of current SalesData record is "Yes", open Accounts
table, insert a new record with "Date"= "Salesdate", "Amount"=
"SalesAmount", "Currency"="usd", etc, etc.

Can this be done?

Thanks for any help
 
Top