By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,350 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Tables and cascading updates question

P: n/a
I have a make-table query that creates a table that shows various
attributes of other tables---the table created by the query is used
for Excel pivot-table linking.

The problem is that whenever an attribute is updated in a table that
was used in the make-table query, the created table's attribute
remains static/unchanged. I understand how to use Primary and Foreign
keys and relationships. But, am I missing something here?

I don't need to show primary keys of other tables in the table created
by the make-table query---I only need to show specific attributes. Is
using a query instead of a table the only way I can ensure that any
updated attributes are reflected in the "view" needed for the Excel
pivot table?

Example-
1. table_A: ColorID, Color
2. table_B: FurnitureID, Furniture

make-table query creates...
3. table_C: Furniture, Color

Is there any way to "cascade update" table C's attributes without
using a query?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
> I don't need to show primary keys of other tables in the table created
by the make-table query---I only need to show specific attributes. Is
using a query instead of a table the only way I can ensure that any
updated attributes are reflected in the "view" needed for the Excel
pivot table?
YES
Is there any way to "cascade update" table C's attributes without
using a query?


NO
Nov 13 '05 #2

P: n/a
> I don't need to show primary keys of other tables in the table created
by the make-table query---I only need to show specific attributes. Is
using a query instead of a table the only way I can ensure that any
updated attributes are reflected in the "view" needed for the Excel
pivot table?
YES
Is there any way to "cascade update" table C's attributes without
using a query?


NO
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.