I decided to change some field names in a table that was already feeding a query. In this particular query, I was using the table twice, once with an index on one situation and again with an index to another situation.
When adding a second table to the query, Access automatically creates an alias by appending _1 to the table name.
After I changed the field names in the underlying table, the field names in query were updated EXCEPT for the table with an alias name!
I tried using an alias name that was different from the Access default, but got the same result.
I suspect that Access could not associate the alias used in the query to the original table name, and consequently did not update the field name in the alias table.
Is there a way to generate a second instance of a table in a query such that Access will be able to identify it as an alias of the original table and update any field name changes made to the original table?
Thanks for any suggestions you may have,
Dan..