Copy and paste in tables

P

Pietro

Hi all,

i have 3 tables: table1,table2,table3
Can i copy the field "receiving date" from "table1" if status in
"table3"<>"closed" or"follow up" to a new record in "table2",by only one
click on a button on a form.
and in case that all the fields of [status]="closed or"follow up",user may
get the message "No records" ?

Regards
 
J

John Vinson

Hi all,

i have 3 tables: table1,table2,table3
Can i copy the field "receiving date" from "table1" if status in
"table3"<>"closed" or"follow up" to a new record in "table2",by only one
click on a button on a form.
and in case that all the fields of [status]="closed or"follow up",user may
get the message "No records" ?

Regards

Yes. Use an Append query.

However - storing this data redundantly in a second table is probably
neither necessary nor a good idea! You can use a Select Query with a
criterion on Status of

NOT IN("Closed", "Follow Up")

This Query will look, work, and feel just like your proposed Table2
but will not require that you store the data redundantly, wasting
space and risking data anomalies; what if a record exists in both
tables and you edit it only in one!?

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top