Linked Tables in a query...

[Guest]

I am working with a simple select query. I have two tables of related data.
The first table is a list of transactions and the second is account
inforamation. The first table contains a related account id which links it
to the table "Accounts". I link these two tables so that I can display an
account description in the results.

Here's the problem, I may want to delete a transaction. However, when I
attempt with the link, Access assumes that I want to delete a record from the
Accounts table and throws up an error message regarding other related data to
the Accounts table. This is a good thing, since I am not trying to delete
Accounts at all.

The questions now is, how can I show related account information and still
be able to delete a transaction? Is it possible?

Any help is appreciated.

 

[John W. Vinson]

I am working with a simple select query. I have two tables of related data.
The first table is a list of transactions and the second is account
inforamation. The first table contains a related account id which links it
to the table "Accounts". I link these two tables so that I can display an
account description in the results.

Here's the problem, I may want to delete a transaction. However, when I
attempt with the link, Access assumes that I want to delete a record from the
Accounts table and throws up an error message regarding other related data to
the Accounts table. This is a good thing, since I am not trying to delete
Accounts at all.

The questions now is, how can I show related account information and still
be able to delete a transaction? Is it possible?

Any help is appreciated.

Several ways to do this. The simplest might be to use a Form based on
the Accounts table (the "one" side) with a Subform based on the
transactions table. You can easily delete a record from the subform.

If you're working in a query datasheet.... well, don't work in query
datasheets.

John W. Vinson [MVP]