query to move row to different table.

[Guest]

I have a table called "Outbound Calls", in this table is our leads' info. I
want to make a query that uses a form which I only input the phone number on.
I want the query to take the row the phone number corresponds to and put it
in the "Contacted" table. I don't want the row to be left in the "Outbound
Calls" table. I'm not even sure what the type of query should be, could you
possibly help me out, a push in the right direction would be much
appreciated. Thank you very much,
Nick Cherry

 

[JohnFol]

You would need 2 queries, one to do the Insert Into TblContacted, and the
other to do a Delete from tblOutbound . .

Alternatively, I'd suggest a call is a call, ie an entity that can be
represented as a table. If the call was sucessful, and the customer
contacted then this is an attribute of the call. The contact can be
represented by a field in the table. (Contacted Yes / No).

The "Leads" form is then based on a "select from Calls where Contacted =
False". When contacted the field is set to true, thus removing it from the
form.