Promoted from Table to Table

[Smee]

Hey everyone,

I have 2 tables.

The 1st table stores details of invoices sent out to clients for paying.

The 2nd table stores details of projected invoices, and when to send them out.

What I want to do is allow projected invoices (2nd table) to be "promoted" to actual invoices (in the 1st table) at the press of a button by the user.

i.e. The record is added to the 1st table, and deleted from the 2nd table.

Both tables have almost identical fields, but the 2nd table has more. Therefore, whether in code, or whatever, some fields will need ignoring during the process.

Hope someone can help

Thanks

 

[Mile-O]

All you need to do is build an APPEND QUERY and set your criteria - look under Query -> Update Query in the Query Design View.

 

[Smee]

Thanks Mile, useful advice as usual, and very quick.

Feeling suitably stupid for not getting that one, particularly having played with append queries a few weeks ago. Just didn't put 2 & 2 together.

 

[Mile-O]

Just don't forget to use a DELETE query, too, to remove the promoted records from the first table if, indeed, that's necessary.

 

[Smee]

Alternatives always welcome

Thanks Pat, I'll give that a go. Could be significantly easier.