updatable query

[Guest]

I'm using the results of a select query as the creteria for another query's
field. I am unable to edit any data for the second query's table.

If I use a make table query and use that table for the creteria, I'm
successfuly but have added another step.

How can I make the first option feasable?

And I don't seem to ever be able to get to the window that edits referential
integrity/cascading.

 

[Chris2]

I'm using the results of a select query as the creteria for another query's
field. I am unable to edit any data for the second query's table.

If I use a make table query and use that table for the creteria, I'm
successfuly but have added another step.

How can I make the first option feasable?

Your second paragraph outlines the workaround option to the problem
noted in the first paragraph.

And I don't seem to ever be able to get to the window that edits referential
integrity/cascading.

What do you mean?

What happens when you try?

Sincerely,

Chris O.

 

[John Spencer]

Hard to say since we can't see your queries.

If you drop the criteria, can you edit records in the second query?


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

I can't even open/get to the window to edit referentail/cascading.

 

[Chris2]

I can't even open/get to the window to edit referentail/cascading.

sierralightfoot,

So, when you click (double left or single right) on a referential
integrity line in the Relationships window, nothing at all happens?


Sincerely,

Chris O.

 

[Guest]

I get the join properties window but never get the integrity/cascade window
too.

 

[Chris2]

I get the join properties window but never get the integrity/cascade window
too.


"Chris2" wrote:

sierralightfoot,

Is the caption for the dialog box, "Edit Relationships"? If so, then
that's the box in question as far as I know.

FYI, I'm using Access 2000 (yes, still).

Later versions may be configured differently.


Sincerely,

Chris O.

 

[John W. Vinson]

I get the join properties window but never get the integrity/cascade
window too.

You need to be joining from the Primary Key field, or from some other field
with a unique Index, in order to get the relational integrity options.

John W. Vinson [MVP]

 

[Guest]

I am using a primary key in the join, but still never get the integrity option.

 

[John W. Vinson]

I am using a primary key in the join, but still never get the integrity option.

Are these tables linked from a backend database? If so, you must establish RI
in the backend database where the tables reside - not in the frontend.

John W. Vinson [MVP]

 

[Daniel]

I am using a primary key in the join, but still never get the integrity option.

Just confirming that you are going to Tools -> Relationships (in
Access 2000) to set the referential integrity options rather than
trying to set them from the query builder (which you cannot do).

 

[Guest]

When I go tool,relationship I do not get edit relationship. I want to edit
the present relationship. Let me explore the backend database issue, which
I'm unfamilar with.

 

[John W. Vinson]

When I go tool,relationship I do not get edit relationship. I want to edit
the present relationship. Let me explore the backend database issue, which
I'm unfamilar with.

Take a look at the Tables window. Do the tables have a little arrow icon next
to the tablename? If so, the database you have open just has links to the
actual tables. To set relationships you need to view the table's properties
and determine where the "backend" database is - it may be named with _BE as a
suffix on the database name, but it could be anything. You'll need to open
that backend database to set the relationships.

John W. Vinson [MVP]

 

[Chris2]

When I go tool,relationship I do not get edit relationship.

sierralightfoot,

You would not get "Edit Relationships" when going to
Tools>Relationships.

You would get to a window titled, "Relationships".

You right click on that window, select "Show Table", and select all
the tables you want to appear in that window (some tables may already
be showing when you first open it).

Tables appear as boxes with their titles and a list of their columns.

All tables with relationships have lines drawn between them.

You may establish new relationships by dragging and dropping column
names between tables. This will create a line between the tables in
question.

You may get to "Edit Relationships" by double left-clicking or single
right-clicking on a relationship line.

Let me explore the backend database issue, which
I'm unfamilar with.

Most databases that are used by more than one person are "split".

All of the data is kept in one "backend" database that is usually on a
computer server.

Users each get a "client" database version that have "linked" tables
that refer to the backend database (over the network). Users run
their queries and do their work on their client databases.


Sincerely,

Chris O.