moving data

[elmister]

Hello fellow Access Gods,

I have a little issues. How could i move one record from one table to another table when a criteria is met. example.

Table1 : has three fields. serial , field1, feild2,

Table2: serial , field1, feild2,



Then a form that user could pull up or enter the info of serial , field1, feild2. Mind you that Field1 and Two are entered in stages .

I need to make it so that when serial and field1 and field2 are true. Then Have the DB somehow move that record to Table2.

Is this posible.


Any guidance will help thank you.

[orange]

It seems that you have not normalized your tables.
see http://en.wikipedia.org/wiki/Database_normalization

No apparent reason for having the same fields in 2 different tables.

[elmister]

This was a example.

[orange]

Please ask your question and use a real data example.

[elmister]

Orange,
Sorry, I just thought by keeping it simple it would be easier to understand. I just need a boost, i could modify it and make it work with our current system. No need to display our database to strangers. thanks anyways.

[orange]

You can try this Make Table syntax

Select
Serial
,field1
,field2
INTo MyNewTable
From MyExistingTable

You should not feel that because I was asking for actual field names that you were exposing your database. We're here to help/advise. It impedes communication when people deal in generalities. A sample of an issue expedites communication. Although you may be extremely familiar with your situation/environment, the rest of us are often guessing at what you have, what you need and how much experience you have.

Good luck with your project.