relationship problem

[troy]

I am trying to run append queries from my 5 tables that are linked to
another database into 5 tables in my current database. I filter them from
within a form. Say I filter by the officer field and I have 30 records. I
would like to run append and delete queries to accomplish this. The problem
is, when I try to setup the relationship, the cascade update and delete are
grayed out.

Is there another way of accomplishing this?

Thanks!

 

[John Vinson]

I am trying to run append queries from my 5 tables that are linked to
another database into 5 tables in my current database. I filter them from
within a form. Say I filter by the officer field and I have 30 records. I
would like to run append and delete queries to accomplish this. The problem
is, when I try to setup the relationship, the cascade update and delete are
grayed out.

You can only establish relationships (and cascades) in the database
which actually contains the tables.

Running an Append query followed by a Delete query from code may be
your best bet. For safety, wrap the query executions in a Transaction;
this will ensure that either both queries or neither query runs - see
the online help for Transactions or post back for sample code.

John W. Vinson[MVP]