G'day,
I have created a query in query design view and it works ok on the two tables I am using. I have now added an extra field to one of the two tables (tblVehicle).
If I drag a new copy of the table into the existing query in design view it is now called (tblVehicle1). Examination of same reveals the new field added.
To make the query work I new need to change source table name for each field in the query from tblVehicle to tblVehicle1
Question:- Is it possible to refresh the original table tblVehicle and thus save time??
I have created a query in query design view and it works ok on the two tables I am using. I have now added an extra field to one of the two tables (tblVehicle).
If I drag a new copy of the table into the existing query in design view it is now called (tblVehicle1). Examination of same reveals the new field added.
To make the query work I new need to change source table name for each field in the query from tblVehicle to tblVehicle1
Question:- Is it possible to refresh the original table tblVehicle and thus save time??