
05-02-2002, 02:28 PM
|
 |
Junior Contributor
|
|
Join Date: May 2002
Location: Guess! It's really HOT!!
Posts: 314
|
|
Make Table Query Updateable?
|
If I create a query in Access 02 based on information from another table(s), and then turn that query into a table itself...will it continue to be updated as new records are put into the other tables the query is based on????
Example: I create a query based on field1, field2, and field3
field1 and field2 are in table A
and field3 is in table B
then I make this query into table C. (Using make table query)
will Table C's records be automatically updated when new records are placed in these fields in tables A and B?
i.e. will field1, 2 and 3 in table C contain the same info as in table A and B after the make table has been created?
Sheesh...I almost don't understand myself!?
|
__________________
He who laughs last...Thinks slowest.
|