468,765 Members | 1,094 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

Copy of table gets emptied with original table

Hi:

I have set up a table, and a temporary copy of the table which I wish to use for some
processing. I have found that using a query to empty the ORIGINAL table, the copy of the
table gets emptied too.

Both are in the same dfatabase and have different names.

Can someone tell me how to breath that irritating link!

Thanks
Nov 13 '05 #1
5 1152
MA

"John Baker" <Ba******@Verizon.net> ha scritto nel messaggio
news:0s********************************@4ax.com...
Hi:

I have set up a table, and a temporary copy of the table which I wish to use for some processing. I have found that using a query to empty the ORIGINAL table, the copy of the table gets emptied too.

Both are in the same dfatabase and have different names.

Can someone tell me how to breath that irritating link!

Thanks


Are they joined with cascade eliminations?
MAssimiliano
Nov 13 '05 #2
I have no idea -- how to I tell if they are?

Best

John Baker

"MA" <ma****@massimilianoamendola.it> wrote:

"John Baker" <Ba******@Verizon.net> ha scritto nel messaggio
news:0s********************************@4ax.com.. .
Hi:

I have set up a table, and a temporary copy of the table which I wish to

use for some
processing. I have found that using a query to empty the ORIGINAL table,

the copy of the
table gets emptied too.

Both are in the same dfatabase and have different names.

Can someone tell me how to breath that irritating link!

Thanks


Are they joined with cascade eliminations?
MAssimiliano


Nov 13 '05 #3
When you are viewing the Database Window. Click the Relationships Icon on
the top-right of your toolbar. Then look for the 2 tables. Double click on
the join between them and see if you have selected Cascading Deletes. This
means, that when you delete records in the PRIMARY table, all RELATED
records in the related table also get deleted.

HTH
Paul

"John Baker" <Ba******@Verizon.net> wrote in message
news:h4********************************@4ax.com...
I have no idea -- how to I tell if they are?

Best

John Baker

"MA" <ma****@massimilianoamendola.it> wrote:

"John Baker" <Ba******@Verizon.net> ha scritto nel messaggio
news:0s********************************@4ax.com. ..
Hi:

I have set up a table, and a temporary copy of the table which I wish to

use for some
processing. I have found that using a query to empty the ORIGINAL table,

the copy of the
table gets emptied too.

Both are in the same dfatabase and have different names.

Can someone tell me how to breath that irritating link!

Thanks


Are they joined with cascade eliminations?
MAssimiliano

Nov 13 '05 #4
Paul:

Thank you. I have looked in the DB window and the tables dont apear at all (although the
tables I would expect to see are there). I imagine this means they dont have linkage at
all (at least not of this sort). Are there any other things that could cause this
condition?

John

"Paul" <pz****@rogers.com> wrote:
When you are viewing the Database Window. Click the Relationships Icon on
the top-right of your toolbar. Then look for the 2 tables. Double click on
the join between them and see if you have selected Cascading Deletes. This
means, that when you delete records in the PRIMARY table, all RELATED
records in the related table also get deleted.

HTH
Paul

"John Baker" <Ba******@Verizon.net> wrote in message
news:h4********************************@4ax.com.. .
I have no idea -- how to I tell if they are?

Best

John Baker

"MA" <ma****@massimilianoamendola.it> wrote:

"John Baker" <Ba******@Verizon.net> ha scritto nel messaggio
news:0s********************************@4ax.com ...
Hi:

I have set up a table, and a temporary copy of the table which I wish to
use for some
processing. I have found that using a query to empty the ORIGINAL table,
the copy of the
table gets emptied too.

Both are in the same dfatabase and have different names.

Can someone tell me how to breath that irritating link!

Thanks

Are they joined with cascade eliminations?
MAssimiliano


Nov 13 '05 #5
Well, just because you dont see the tables, does not mean they are not
there.

There are several icons on the toolbar that allow you to see connections.
Just to play it safe. Try adding the tables to the window...if they appear
with a number to the right of the table ... PrimaryTable_1 means that there
is already an instance of if. Pressing the buttons at the top of your
screen will show the tables. Read the tip on the icon to see what its
callled first.
"John Baker" <Ba******@Verizon.net> wrote in message
news:50********************************@4ax.com...
Paul:

Thank you. I have looked in the DB window and the tables dont apear at all
(although the
tables I would expect to see are there). I imagine this means they dont
have linkage at
all (at least not of this sort). Are there any other things that could
cause this
condition?

John

"Paul" <pz****@rogers.com> wrote:
When you are viewing the Database Window. Click the Relationships Icon on
the top-right of your toolbar. Then look for the 2 tables. Double click
on
the join between them and see if you have selected Cascading Deletes.
This
means, that when you delete records in the PRIMARY table, all RELATED
records in the related table also get deleted.

HTH
Paul

"John Baker" <Ba******@Verizon.net> wrote in message
news:h4********************************@4ax.com. ..
I have no idea -- how to I tell if they are?

Best

John Baker

"MA" <ma****@massimilianoamendola.it> wrote:
"John Baker" <Ba******@Verizon.net> ha scritto nel messaggio
news:0s********************************@4ax.co m...
> Hi:
>
> I have set up a table, and a temporary copy of the table which I wish
> to
use for some
> processing. I have found that using a query to empty the ORIGINAL
> table,
the copy of the
> table gets emptied too.
>
> Both are in the same dfatabase and have different names.
>
> Can someone tell me how to breath that irritating link!
>
> Thanks

Are they joined with cascade eliminations?
MAssimiliano

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

42 posts views Thread by Edward Diener | last post: by
4 posts views Thread by Kevin | last post: by
19 posts views Thread by davidgordon | last post: by
7 posts views Thread by lgbjr | last post: by
17 posts views Thread by Steve | last post: by
4 posts views Thread by colmkav | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.