table from a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make a table (table A) based on another table (table B)that I have.
I only want some of the fields that are in table B to be in table A. I also
need additional fields in table A. When i update a field in table B, I need
all of the fields in table A to also change accordingly? How do I begin to
create this? thank you for your help.
 
Russ,

To be honest, it really sounds like you are trying to do something very
irregular, and highly suspicious. This is not normally good practice in
a database, where "one place only for each piece of data, and every
piece of data in its place" is a fundamental principle. It could be
that a spreadsheet is a more applicable tool for your purpose, or it
could be that there is a better way within Access to achieve your
purpose. Maybe if you could post back with an explanation of what you
are trying to achieve, someone may be able to offer some useful advice.
 
Back
Top