If table is deleted

[Guest]

Hi,

I have a query that links two tables (table1 & table2). The first column in
each table is linked in a 1-1 join. My question is this -

#1) I delete table1 and then recreate table 1 the query still works
#2) I delete table1 then open up the query in design view, then recreate
table1 - then the links are gone.

How do I stop the query from eliminating the links - this is annoying
because when I am changing tables sometimes I have to go back and recreate a
lot of work in the queries.

Thanks for your help!

 

[Guest]

Hi Jeff

I don't really understand what you're trying to do but could you use an
update / append query instead (or something else) instead of deleteing the
table

Just a thought