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
Click to expand...

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]
 
Top