Can yourefresh a table in Query Design view (1 Viewer)

[HealthyB1]

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??

 

[Minty]

Just close and reopen your original query - the extra field should be in the table representation on the query designer.

 

[arnelgp]

set the Alias of tblVehicle1 to tblVehicle.