By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

how can you tell in advance which table's record will be deleted?

P: n/a
MLH
Put 2 tables in a qbe grid & link 'em
so as to list only records in tblA that
have related records in tblB.

Run the query. HiLite a row. Press
delete key. A record is deleted. How
can you design the query so that you
KNOW in advance which table a
record will be deleted from.
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In article <bs********************************@4ax.com>, MLH
<CR**@NorthState.netSun, 1 Jun 2008 15:44:10 writes
>Put 2 tables in a qbe grid & link 'em
so as to list only records in tblA that
have related records in tblB.

Run the query. HiLite a row. Press
delete key. A record is deleted. How
can you design the query so that you
KNOW in advance which table a
record will be deleted from.
The relationship is usually one-to-many. It is the "many" side that is
deleted.

I don't think you can design the query to chose that the "one" side is
deleted.
--
Les Desser
(The Reply-to address IS valid)
Jun 27 '08 #2

P: n/a
MLH
On Sun, 1 Jun 2008 22:38:02 +0100, Les Desser
<Ne*******@dessergroup.comwrote:
>In article <bs********************************@4ax.com>, MLH
<CR**@NorthState.netSun, 1 Jun 2008 15:44:10 writes
>>Put 2 tables in a qbe grid & link 'em
so as to list only records in tblA that
have related records in tblB.

Run the query. HiLite a row. Press
delete key. A record is deleted. How
can you design the query so that you
KNOW in advance which table a
record will be deleted from.

The relationship is usually one-to-many. It is the "many" side that is
deleted.

I don't think you can design the query to chose that the "one" side is
deleted.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
OK. Lemme stew on that for a while. Thx.
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.