From: khussey on 5 Feb 2010 13:12
From: Jeff Boyce on 5 Feb 2010 14:32
Having two copies of the same data exposes your database to integrity
More info, please...
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)discussions.microsoft.com> wrote in message
From: Bob Barrows on 5 Feb 2010 14:59
An Append or Update query - see online help
From: John W. Vinson on 5 Feb 2010 16:59
On Fri, 5 Feb 2010 10:12:01 -0800, khussey <khussey(a)discussions.microsoft.com>
< 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]