471,081 Members | 1,029 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,081 software developers and data experts.

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.