From: khussey on

From: Jeff Boyce on

Having two copies of the same data exposes your database to integrity

More info, please...


Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer

"khussey" <khussey(a)> wrote in message
> --
> kh

From: Bob Barrows on
An Append or Update query - see online help

Bob Barrows

From: John W. Vinson on
On Fri, 5 Feb 2010 10:12:01 -0800, khussey <khussey(a)>

< nothing >

It's considered polite to use the big textbox to ask a comprehensible
question, not just use the subject line.

As noted elsethread, this is probably a Bad Idea - relational databases use
the Grandmother's Pantry Principle, "a place - ONE place! - for everything,
everything in its place". Storing the same data in multiple tables risks
anomalies if one or the other table gets edited; you then have "the same" data
actually being different.

That said, an appropriate Query (append or update) could do this. If you would
like help with a query post some more information about your tables and what
you're trying to do.

John W. Vinson [MVP]