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?